Sajha.com Archives
MsAccess Help
I'm trying to import an Excel file to Ms 14-Oct-03
wacked
Wacked, When importing choose the fie 14-Oct-03
Biruwa
Username
Post
wacked
Posted on 14-Oct-03 08:32 AM
I'm trying to import an Excel file to Ms Access but the leading zero disappears when i import it.
pls help
It's a 5 digit zip code field
thank you
Biruwa
Posted on 14-Oct-03 09:40 AM
Wacked,
When importing choose the field type for your zip code as "text".
Another way of getting around the problem is to put ' (quotation mark) infront of all your zip codes.
