Exporting Table to text is droping number format

  • Thread starter Thread starter Blake
  • Start date Start date
B

Blake

Hello, Im using Access 2000 and having trouble exporting a
table to a text file. The table has many numeric fields,
Double, Fixed, 5 decimal or auto. When I export, the data
is dropped and I get the following. Number starting as
2000 becomes 2000.00. starting as 1.2345 becomes 1.23. The
formating is always two decimals leading me to beleave
currency with no $ symbol. What should I do to pass the
values raw, without changeing or rounding them.
Thank you for your continued support
Blake
 
Write a query.
Use the format function on each filed that is giving your trouble.
Export the query.
 
Back
Top