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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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)
 
Back
Top