Export query data to text file


K

Kevin

When I export the query file data to an Excel file, the
exported numerical data can have the same 3 decimal places
in the Excel spreadsheet. However, when I tried to export
the same query data to a text file, I noted that all
numeric data were truncated to 2 decimal places. Does
anyone know how to configure this so that the exact
numerical data can be exported to text file, ie to
maintain the same number of decimal places as in the query.

Many thanks,

Kevin
 
Ad

Advertisements

D

david epsom dot com dot au

numeric precision is a regional setting, set in control panel,

Or you can convert the numbers to text fields, and export as
text instead of as numbers (which would probably also require
a change to your export specification or schema.ini file)

(david)
 
Ad

Advertisements

D

david epsom dot com dot au

Export to text uses the regional setting: export to excel
does not. It is a reasonable way to do things for most
Access users (not for developers, but I normally use VBA
code loops to import/export text)

(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top