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.
 
Back
Top