Zeros cut off - Help!

  • Thread starter Thread starter kyrasvc
  • Start date Start date
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?
 
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.
 
Back
Top