Export query data to text file

[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

 

[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)

 

[Kevin]

Thank you. But why the export to Excel does not have the
precision problem ?

 

[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)