export teble to text keeping number format

  • Thread starter Thread starter Yossi evenzur
  • Start date Start date
Y

Yossi evenzur

Hi i export a table with 8 decimal places to text files and the export
reduces it to only 2 decimal digits. exporting with keeping the format is
limited due to the number of lines that can be copied to the clipboard.
 
Don't export the table itself. Export a query based on that table, and
format the field with the Format function. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"ExportFormattedFixed.MDB" which illustrates how to do this. Look at the
query "qryExportFormatted" for details on formatting different formats.

You can download the sample for free here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=351

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Create a query and use the Format function to force the number of decimals
that you want to see. Then export the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top