Decimal positions truncating when exporting to text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top