export table to text and retain leading zeros

[john]

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]

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

Format([MyNumberField], "00000000")

hth,