Access VBA - Append query to append only records with 'new' ID

Access 2016. I have a table tblVolunteers, which is a permanent table of people. I need to import to it a new CSV I get every day. The new CSV has some new people, as well as some of the people already in tblVolunteers. I import The new CSV into another (helper) table tblVolunteers_NewCSV temporarily.

So I need to do an Append query to append records from tblVolunteers_NewCSV to tblVolunteers. But how do I only append those with new IDs? (There's a primary key field of ApplicationID in both tables. The structure of the two tables is the same)

Thanks for any help.
Who is Participating?
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
It would be helpful to have some info on the structure of you table but your query should be
INSERT INTO YourTable[(field1[, field2,field3...) VALUES ('Value1','Value2','Value3') WHERE [TheFieldToMatch] NOT IN (SELECT [TheFieldToMatch] From YourTable

Open in new window

INSERT INTO YourTable[(field1[, field2,field3...) SELECT (Fields From TheOtherTabel) WHERE  [TheFieldToMatch] NOT IN (SELECT [TheFieldToMatch] From YourTable

Open in new window

hindersalivaAuthor Commented:
Thanks great, John!

I needed all the fields so deleted the Field List. That worked too.
hindersalivaAuthor Commented:
I hadn't thought of NOT IN
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.