Connecting Tech Pros Worldwide Forums | Help | Site Map

CSV Export MS Access

Newbie
 
Join Date: Jul 2007
Posts: 2
#1: Jul 13 '07
Hi -

In MS Access 2002:

I'm exporting a Query to a CSV file. I have doubles (i.e. floats) with a high precision (i.e. 6 places after decimal) - but when I export to CSV, my float's precision are trimmed to only 2 places after the decimal.

I've looked into the Advanced settings in the export wizard... but nothing about precision is mentioned.

Thanks!

Newbie
 
Join Date: Jul 2007
Posts: 2
#2: Jul 13 '07

re: CSV Export MS Access


Interesting.

So I exported it first to an Excell 2002 file.

Then "Saved As..." a .CSV file, and my float's precision was preserved.

Kinda round-a-bout...
Reply