Export Data to Text file - Truncation of numeric data

  • Thread starter Thread starter JM
  • Start date Start date
J

JM

I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!
 
Hi JM,

Create a query on your table and export that. In the query, use a
calculated field with the Format() function to format the number the way
you like, e.g.:

fNumberField: Format([NumberField], "#,##0.000")


I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Did you post this same problem a few days ago?


I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!
 
I'll give it a try.
Thanks for your help.
-----Original Message-----
Hi JM,

Create a query on your table and export that. In the query, use a
calculated field with the Format() function to format the number the way
you like, e.g.:

fNumberField: Format([NumberField], "#,##0.000")


I am trying export data from a table to a text file. For
some numeric fields the data is truncated or rounded
where there are only two decimal places. Viewing data in
the table shows three decimal places. What do I need to
do to bring over all the decimal places into the text
file?

Thanks!
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top