Access 97 Export to text dropping decimal spaces

[Guest]

We are exporting and access table, export delimited, and the statistics have
4 spaces after the decimal. The table reflects for example, 1.7542; after
export to text the data has changed to 1.75. I have tried an export spec., I
have tried changing the field properties to Text; I have tried Double, 4
spaces, on design; etc. Anyone have this issue and how did you fix it - any
suggestions other than send it to Excel (we are trying to avoid at this point
since another application is picking up this text file and using it).

Thank you
melakeside

 

[Douglas J. Steele]

Try creating a query, and use the Format function on the field. Export the
query rather than the table.

 

[Guest]

see also "doubles are rounded when exporting to ASCII",

change the regional settings of your computer, option "No. of decimals after
decimal"

Bart

 

[Guest]

This was driving me nuts.
The double field in the table , when export delimited had a decimal point
but no decimal digits. (The integer field also had a decimal point, which
seemed redundant.)
But your hint was right on. The regional settings had the number of decimal
places set to zero.
How retarded is that?

 

[Guest]

Thank you very much Bart for explaining that! I'm working in Access 2003 and
was losing many of my decimal places when exporting a table to .csv format.

Pat