Good Morning:

I have a customer database that tracks names, socials etc. I have a large excel list I need to import that includes names with no social security numbers. The primary key is the social security number for each individual.

Can I import the list without the socials and match each name to the names in the DB and export with the socials included?

Thank you very much.

You would need to import to a new table.
Then create a query using the current and the imported table to match the values and create an output with the required fields.

Thank you Peter, but can you give me information about how to match the values and create and output?

Thanks.

I have the following:

SELECT *
FROM incentives LEFT JOIN contacts ON incentives.SSN = contacts.SSN;


But none of the social security numbers from the CONTACTS table are showing up on the INCENTIVES table though each record from the INCENTIVES table is present.

Please help?

From your Q...
....and match each name to the names in the DB ....

So you have to join on the name fields.and include the SSN from the current table.
I don't know which is the imported table in your query.