Avoid truncation of double number fields when exporting query to t

[Guest]

I am using Access 2003 and need to export data to a text file format. The
data is in double number format and has 9 decimal places. When I export the
data to the txt file the number of decimal places is truncated to two.
How do I get access to export the data with nine decimal places.

 

[Allen Browne]

There are 2 solutions suggested in this kb article:
Exporting to Text File Truncates to Two Decimals Places
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208408