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?
 
G

Guest

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
Query to text file cuts my leading zeros off. 4
ignoring format/control codes exporting data from access to excel 21
Zero Upload Speed 6
Cut & Paste in Excel without erasing cell borders? 1
How do I keep leading zeros and remove the decimal point when expo 2

Top