Export of table as *.csv reduces doubles' precision to only 2 dec.

[Guest]

When I export an access 2003 table as a *.csv file, I am losing decimal
places in the floating point numbers after the export. The preview shows the
format with the proper number of decimal places that I indicated with the
number format; however, the actual file exported is not the same as the
preview: the numbers have lost precision and my calculations are off.

Any suggestions would be appreciated.

Thanks,
Dave

 

[John Vinson]

When I export an access 2003 table as a *.csv file, I am losing decimal
places in the floating point numbers after the export. The preview shows the
format with the proper number of decimal places that I indicated with the
number format; however, the actual file exported is not the same as the
preview: the numbers have lost precision and my calculations are off.

I'd suggest using the Format() function to create a calculated Text
field, and export that.


John W. Vinson[MVP]