Exporting fixed width data

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

Guest

I am doing a fixed width export from a table and trying to keep the leading
zeros in a field the zeros are in the table but lost after the export
 
Create a query that is based on the table. In place of the field with the
leading zeroes, use a calculated field with an expression similar to this:

MyFieldToExport: Format([RealFieldName], "0000000000")

In the above example, I've assumed that you want 10 characters in the
exported value. Change the number of zeroes to meet your needs.

Then export this query.
 
Back
Top