Decimal positions truncating when exporting to text file

S

smars66

I have a table with a decimal field. There are 4 decimal positions. When I export the table to a comma delimited text file, it truncates the last 2 decimal positions. The export goes through a wizard and I think the decimals are getting truncated in the wizard. Does anyone know how to edit the wizard parameters?
 
K

Ken Snell

Create a query that will select the records from the table. Replace the
"decimal" field with a calculated field that uses the Format function to
give you four decimal places:
OutPutField: Format([FieldName], "0.0000")

--

Ken Snell
<MS ACCESS MVP>

smars66 said:
I have a table with a decimal field. There are 4 decimal positions. When I
Click to expand...
export the table to a comma delimited text file, it truncates the last 2
decimal positions. The export goes through a wizard and I think the decimals
are getting truncated in the wizard. Does anyone know how to edit the wizard
parameters?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Transfer Text, Export Delimited w/ Number formated to 4 decimals. 1
Exporting text files 5
exporting to text need decimals 1
Move Chart with Text 0
Decimal Truncation Issue upon Import - Access 2007 1
TransferText acExportDelim unexpectedly truncates numeric field 4
Adding Cost Field to Appointment 0

Top