export teble to text keeping number format

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.
 
R

Roger Carlson

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
 
J

Jerry Whittle

Create a query and use the Format function to force the number of decimals
that you want to see. Then export the query.
 
Top