Data truncated when exporting to csv file

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
 
K

Ken Snell

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

Adding data to MS Access from csv file 0
import csv truncation 1
EXPORT QUery with memo field to excel, truncated data 2
Exporting CSV Data 0
Exporting from Access 2007 to a .csv file 0
Access 2003 memo field truncated while exporting as RTF 0
Export truncated in RTF 6
Export to CSV text values not list index values 1

Top