Decimal point rounded off when exporting.

[Chris Moore]

Hi,

I'm running into an issue when exporting a table to a .csv file. The table
contains columns of numbers many of which contain a decimal point and three
digits after the decimal. For example 5.123. The problem is that once the
table has been exported to the .csv file the third number (the thousandth)
has been rounded and I only get the hundredth (for example 5.12). Have tried
Access 2002 and 2003 with the same results. The data type of the columns is
Number, Field Size is Double, with Decimal Places set to Auto. Any
suggestions? Thanks in advance for your help.

-Chris

 

[Jerry Whittle]

Hi,

Instead of exporting the table directly, create a query based on the table.
In the fields having the problem, format them so that the correct number of
decimals show. It's possible that a side effect may be trailling zeros
though. It could also export the data as text with quotation marks around it
although you can set the text qualifier to None.

Formatted: Format([numDecimals],"0.000")

Now what happens when it gets into Excel can be another question.