Export Number field and losing digits

  • Thread starter Thread starter Alan Barton
  • Start date Start date
A

Alan Barton

I am trying to export a number field that has three or
four digits to a text file. When the wizard comes up I
see that it shows the three or four digits but when it
actually exports then it only gives me two digits. The
table has the number setup as double and 6 decimal places.

Please advise!
 
Create a query that is based on the table that you wish to export. Instead
of the number field in the query, use a calculated field that uses the
Format function to format the number the way you wish:
NumberF: Format([NumberFieldName], "0.000000")
 
Two options:

Use the option noted in my reply to Alan.

Or

Create an Export Specification (click on Advanced button in the Wizard
window and set the parameters of the fields, then save it and use it in your
export, either manual or via TransferText).
 
Back
Top