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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import csv truncation 1
truncation of "memo" datatype during export 2
Decimals Lost when Exporting to CSV file 5
EXPORT QUery with memo field to excel, truncated data 2
transfer to excel 1
Export truncated in RTF 6
Data changes during Export 3
Access2000 Export to delimited text is truncating decimals 2

Back
Top