export Access table as .csv

[Nancy]

Hi,

I am exporting an Access table as a text .csv file. One column of the table is formated as number, double with auto decimal places. When the table is exported, it is rounding .013 as 0.01 and .001 as 1.Oe-03.

Can anyone tell me how to correctly export the table numbers exactly as shown in the table?

I appreciate any help I can get!
N

[thhui]

Normally, you export an access table to csv without formating. (raw data in table)
If it does with formating, it is out of the specification you use.
Try to overwrite it by setting it yourself.
Access somehow scan the data and guess what is the meaningful format of the column fields type.

If it still not works, then use the schema.ini to help the exporting by manual formatting the specification you really want.