Why Access export three decimal but in text file only two decimal

S

Stanley Loh

Can any Access 2003 gurus kindly please advice me on the reason why Access
export table options exports to a text file involving number data type with
three decimal places but resulting in only two decimal places in my text file
content ?
Is it a bug that causes the last decimal digit to be truncated or some
settings that could help rectify this problem of mine ?
 
G

Guest

By default, Access uses your regional settings for number formats
when exporting to text. (Look in control panel, regional settings).

If you want a different format, you have to use the Format function
to convert your numbers to text before you export. You can use
a select query to do this, instead of exporting directly from a table.

(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

Similar Threads

exporting as text cutting off significant digits 2
Transfer Text - Decimal Places 0
Export Currency to a Flat File 6
Export from Access to Text file: Specified number of decimal place 1
Export numeric field to text file with 5 decimal places 2
Exporting numbers to a text file with more than 2 decimal digits 8
Decimal places in mail merge 1
export more than 2 decimal places as text 6

Top