Conversion type error

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

When importing excel spreadsheet into access the SSN is
not converting unless I type the data save the excell
spreadsheet and then import it. I have tried doing a trim
and still the same results. The ones that I type showed
up .
 
I'm not fully understanding your situation. Can you provide more specific
details about the exact steps that you're doing?
 
Excel can have a Column of mixed Text values and Numeric values but Access
can't have a Field with mixed values. Also, since the Import Wizard is
likely to guess your SSN as Long and if you have 10-digit SSN, you have the
overflow problem since Long can only store the number up to 2 ^ 31, just a
bit over 2,000,000,000. You should store SSN as Text in Access since you
are not doing any cals with the SSN.

In Excel, create a "Text SSN" column using the spreadsheet function TEXT()
(check Excel Help). When you import the spreadsheet into Access, skip the
original SSN column and use the "Text SSN" column. Access should be able to
import this as Text without any problems.
 
Back
Top