export table to text and retain leading zeros

john · Nov 25, 2003

i have a table with a number field, which is formated to
pad eight zeros. when i export to a text file i lose the
zero. any suggestions

thanks

Cheryl Fischer · Nov 26, 2003

Export a query based on your table, and use the following to pad your
number:

Format([MyNumberField], "00000000")

hth,