Exporting Access FileLocked
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.