Import EXCEL data with a different data type

[Richard]

I have an ACCESS table, with a field that expects numbers (IDs). I have an
EXCEL table which contains the information for this field, but in text. For
example, the ACCESS table expects SSNs, and the EXCEL table contains names.
There is another table in ACCESS that contains the SSN-name relationship.

The tables are:
1) ACCESS table 1: SSN address
2) ACCESS table 2: SSN name
3) EXCEL table: name address

Is there a way to import the EXCEL table into ACCESS table 1, with ACCESS
converting the names into SSN, using ACCESS table 2?

Thanks.

 

[Ken Snell [MVP]]

Import the EXCEL data into a third ACCESS table that is formatted the same
way as the EXCEL data. Then use append queries (where you join that third
table to one of your first two tables) to insert the correct data into your
"permanent" table where you want to store the data.