Preserving leading zeros in exported text

  • Thread starter Thread starter S Suddes
  • Start date Start date
S

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
 
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.
 
Back
Top