Dec 12 2008, 11:13 AM
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.
Dec 12 2008, 11:15 AM
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.
Dec 12 2008, 11:17 AM
Thank you Peter, but can you give me information about how to match the values and create and output?
Dec 12 2008, 12:26 PM
I have the following:
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.
Dec 13 2008, 06:51 AM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here