Preserving leading zeros in exported text

[S Suddes]

Am unable to preserve leading zeros when exporting
formatted text data in an Access table/query data to
either CSV or Excel spreadsheet.

Suggestions?
Thanks

 

[Ken Snell]

For .csv export, you need to set up an export specification that will export
the text-formatted numbers as text, otherwise when you open the .csv file
(likely in EXCEL), they will be seen as numbers. When you're doing a manual
export, in the wizard window, click the Advanced button and set up the
specification; then save it with a name. Use that name as the Export
Specification argument for the TransferText command (or in the Advanced
window during a manual export, select that specification).

For TransferSpreadsheet or a manual export to EXCEL, you must have the field
in the query that you export be formatted as text.