SSNs

G

Guest

I import information from an excel file where my social security numbers are
just 9 digits. I have to manipulate the column to be 9 characters under
custom to add a leading zero and to remove dashes. I then import that
information into a database where I have the field setup for text. When I go
to look at my items on my table the leading zero is still being dropped. How
can I import my information in from excel to a database where the leading
zero works? I have a query where I have LEN being used to give me the leading
zero, but if I can get a LEN in my table to add leading zeros that would be
great too! Any suggestions welcome.
 
D

Douglas J Steele

Sounds as though you're importing into a Numeric field. Make it a Text
field.
 

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

validation rule for exactly 5 digits, including leading zeros 0
Add A Leading Zero 4
Droping Leading Zeros In Table 4
Exporting to Excel and then reimporting from Excel 1
Update/Append Queries 3
Restore leading zero 3
Import from Excel to Access 1
Transfering Data from Access Report to Excel. 2

Top