How to export excel column into Access without losing the leading.
I have data in one column that must always be 8 numbers, leading zeros are
at least two and at most 5, I have formatted them with the custom number
format 00000### but when I import the file into Access (get external data) ,
Access will drop all leading zeros. I do not see an option to import a .prn
file into Access.
|