Import from CSV

[Stan Denman]

This code to accomplish the task:

INSERT INTO tblClients ( ContactID, SSN, ClientMailingAddr, City, State, Zip )


SELECT tlbCont.ContactID, TempData.ClientSSN, TempData.ClientMailingAddr1, TempData.ClientMailingAddrCity, TempData.ClientMailingAddrState, TempData.ClientMailingAddrZip
FROM TempData INNER JOIN tblCont AS tlbCont ON (TempData.LastName = tlbCont.LastName) AND (TempData.First = tlbCont.FirstName);

Yes you are so right - as I am identifying missing clients and repeating the process I have the risk of creating duplicate records. When Ichange the join to "OUTER JOIN" however I get "syntax error in FROM clause"

[Gicu]

You need to make both joins (for first and last name) have the arrow point towards the target table (tblClients) then add two fields from tblClients to the Select statement and add in the criteria row for each Is Null (make sure there row Append To stays empty for these).
Cheers,

[Stan Denman]

I'm sorry. I remain pretty confused. Here is what I have so far. thank you again for your help. I am just going to do it by hand. I would have had it done by now. MS Access always succeeds in disappointing me.

[Stan Denman]

I don't understand how Dmax is keeping the ContID straight.

[Stan Denman]

OK. never mind. ChatGPT solved it for me!