Convert acess table to csv file

[Guest]

Hi,

I have a table in acess that is 360,000 rows. I want to save as a csv file
so I
Right click --> export as csv.

The problem is that when I view the csv file, I notice that the fields are
rounded to 2 places. The field was not rounded in Acess and the table
specifies decimal places = 8. DOes anyone know what the problem could be?

Thanks

 

[dbwiz.com]

I'm not sure why that is, but I would create a new query and use the
Format() function to display the correct number of decimal places that
you want. Then export that query.

Thanks,
www.dbwiz.com