Question

[Guest]

I have a table with 3,600,000 rows and I want to export this from Access to a
csv file.

The data in the table are numbers that are 8 decimal places - when this is
exported to a csv the decimals are truncated to 2 decimal places.

Question = how do you export to a csv and keep all 8 decimal places.

Thanks for your help

 

[Guest]

Export a query which formats each column, e.g.

SELECT
FORMAT(Number1,"#.00000000"),
FORMAT(Number2,"#.00000000"),
FORMAT(Number3,"#.00000000")
FROM NumbersTable;

As the Format function returns a string make sure you opt for no Text
Qualifier (click the Advanced button in the export dialogue for this option)
if you don't want the values delimited with quotes in the csv file.

Ken Sheridan
Stafford, England

 

[Guest]

Where do you type in SELECT and format.
I using: Right Click --> Export

Thanks

 

[Guest]

You must first create a query based on the table in the usual way. You can
switch from query design view to SQL view and type in the SQL. Open the
query to make sure it returns the data correctly formatted, then save it
under an appropriate name, close it, select it in the database window, and
then Right Click --> Export and proceed as normal, remembering to opt for no
text qualifier if you don't want quotes around each number in the csv file.

Ken Sheridan
Stafford, England

 

[Guest]

Thanks that works well!

You must first create a query based on the table in the usual way. You can
switch from query design view to SQL view and type in the SQL. Open the
query to make sure it returns the data correctly formatted, then save it
under an appropriate name, close it, select it in the database window, and
then Right Click --> Export and proceed as normal, remembering to opt for no
text qualifier if you don't want quotes around each number in the csv file.

Ken Sheridan
Stafford, England