Zeros cut off - Help!

K

kyrasvc

When I import from excel into access, my zero's on the zip code field get cut
off. How can I stop this from happening?
 
J

Jerry Whittle

Import them into a text field instead of a number field. Same thing goes with
Social Security Number. You may need to build the table first then or use an
inport specification to get it right. You'll have to append leading zeros
after changing the existing field from a number to text as the 0's are gone.
 
Top