|
Answer» Hi
I am exporting some data from Access to a CSV ( I need this to be a CSV to import into a bespoke program). Anyway I need some data to hold leading ZEROS but Excel takes these out. I can format the cells to include these but it will not save as a CSV.
Can anyone help at all please?Why do you need to run the data through Excel? Why can't you export your data from Access and then import it to your "bespoke" program?The program imports a CSV FILE that I need to CREATE. I run a query in Access and export as CSV. This automatically opens in Excel WITHOUT the leading zeros. I am trying allsorts to put them back in but to no avail at the moment.I've MANAGED to fix this problem. The trick is not to open in Excel. Thanks for your help.Yes, I was going to ask why you said "This automatically opens in Excel" and suggest that that should not be necessary and not doing so will avoid the problem. Anyway, glad to hear you got it sorted out.
|
