I'm using Access VBA to create a .csv file, including the following line:
objFile.writeline ("FieldName," & rs("Field"))
...where rs("Field") = '001234'
So, the line writes out as FieldName,001234. Good.
However, when I open the .csv file in Excel, Excel thinks '001234' is a number, and displays 1234 (aligning right and truncating zeros). Is there anything in VBA I can do to show the six-character string when opening in Excel?
Thanks in advance.