General discussion
August 3, 2006 at 10:39 AM
russellrl2

Exporting Access File

by russellrl2 . Updated 20 years, 2 months ago

Using Access 2003. Run a query that creates a table with the results. View the table and everything is right. Specifically two fields have numbers (37.4568, -97.34567) with up to 5 digits after the decimal point. When I export the table (to a text file because there are over 250,000 records), the decimal point is trunicated to 2 digits. I have changed the format on the table but did not solve the problem. When I export the wizard shows everything correctly so not sure why it is chopping off some of the digits.

This discussion is locked

All Comments