Decimal Truncation on Export

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

 

[Brian Camire]

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.

 

[Guest]

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?

.