| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i cannot open excel file error Cannot access read-only document me | Excel Worksheet Functions | |||
| Linking Excel to Access. | Excel Discussion (Misc queries) | |||
| Link Access query to refresh an EXCEL file | New Users to Excel | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Threaded Mode
