Data truncated when exporting to csv file

  • Thread starter Thread starter BillV
  • Start date Start date
B

BillV

I am trying to export data from a MS Access table or query
to a csv file. When I do, all my data is truncated (or
actually, rounded) to 2 significant decimal points. For
example, 0.005 comes out as 0.005, but 0.012 comes out as
0.01 and 0.456 comes out as 0.47.

It doesn't seem like specifying a format in the Database
table field or in the query seems to help.

Any way around this problem?
Any explanation?

Thanks,

Bill
 
Post example of the SQL statement that contains the formatting (Format
function) and let's see. Using Format function is the normal way to define
the output.
 
Back
Top