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.