MS Access data conversion - Decimal point rounded off when exporting.

Author

Decimal point rounded off when exporting.

Chris Moore

2006-01-04, 11:24 am

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

2006-01-17, 11:24 am

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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Chris Moore" wrote:

> 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

Sponsored Links