export from access to csv - retain leading zeros

[luciegiles]

Hi,

I am trying to export some data from Access to a csv file. One column of data contains numbers stored as text (in Access) so as to retain leading zeros. When I export to csv the zeros are lost. When I open the file in notepad the zeros are still visible.

I have tried to change the format of the cell to text or specify field length but every time I open the csv again any format changes have disappeared and the field is stored as a number without the zero.

any ideas?

thanks
L

[Sudaraka]

As I remember there was an option in the export process where you need to set the text qualifier (to "), otherwise it decides the field type (text/numeric) based on the content.

Sorry I can't tell you where to find the setting exactly because I don't use Access any more.