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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Editing a cell in Excel spreadsheet 2
How do I make a number start with a zero in a table? 1
ignoring format/control codes exporting data from access to excel 21
Export and Analyze With error 1
Excel Unable to insert cut rows into Excel online anymore? 0
How do I paste from Access to Excel without field names 3
Leading 0's issue from HTML to Access 4

Back
Top