Export from Access to CSV

[bnageshrao]

When I export table to csv file I loose all leading zeros which does not happen when i export it as xls file. What should be done to retain the leading zeros during export to a csv file.

 

[PHV]

Export a formatting query instead of the table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CarrieR]

When going thru the text import wizard (assuming you are pulling into Excel) on step #3 select the field as "text" which will hold leading zeros in Excel.

 

[bnageshrao]

I have to export when i click on File --> Export and choose the file as .csv, i dont see any step number 3 where i can choose field as text.
I also saved it as a query and exported and i ended up loosing leading zeros. What does formatting query means. After saving query do i have to format it? On queries it doesnot allow me to format. Any suggestion is highly appreciated.

 

[PHV]

Example of "formatting" query:
SELECT Format([Numeric Field], '000000') As FormattedField
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886