Decimal Truncation on Export

  • Thread starter Thread starter Puzzled
  • Start date Start date
P

Puzzled

When exporting an Access table to text, the data in any
numeric field gets trucated to 2 decimal places. This
happens for fixed width as well as delimited exports.

I've tried everything to try and keep more decimal places
but nothing works. The only workaround I have is copying
all records into the clipboard, pasting into MSExcel and
then saving it as a text file. Obviously this is
cumbersome if the number of records is more than Excel
can handle.

Does anyone know of a way to preserve more than 2 decimal
places when exporting an Access table into a text file?
 
Create a query based on your table. Instead of including the field(s) in
question in the query, include an expression that uses the Format function
to format the number as a string to the desired number of decimal places --
for example:

Format([Your Numeric Field],"0.0000")

for four decimal places. Then, export the query instead of the table.
 
Thanks Brian. Tried the fix and it works!
-----Original Message-----
Create a query based on your table. Instead of including the field(s) in
question in the query, include an expression that uses the Format function
to format the number as a string to the desired number of decimal places --
for example:

Format([Your Numeric Field],"0.0000")

for four decimal places. Then, export the query instead of the table.


When exporting an Access table to text, the data in any
numeric field gets trucated to 2 decimal places. This
happens for fixed width as well as delimited exports.

I've tried everything to try and keep more decimal places
but nothing works. The only workaround I have is copying
all records into the clipboard, pasting into MSExcel and
then saving it as a text file. Obviously this is
cumbersome if the number of records is more than Excel
can handle.

Does anyone know of a way to preserve more than 2 decimal
places when exporting an Access table into a text file?


.
 
Back
Top