By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

export from access to csv - retain leading zeros

P: 56

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?

Jun 1 '11 #1
Share this Question
Share on Google+
1 Reply

P: 55
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.
Jun 1 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.