Views: 4 Size: 42.9 KB">Example.zip
In real life application...
1. I have created a table linked to an excel file. (The reason for this is because i will have to pull data in to my access db on a weekly basis and its easier to link to a file that is structured and only the data will change.)
2. Identify records that exist in a staging table but do not exist in the Main Table.
3. Append the records from step 2 into the Main table.
I have attached the example db with my attempt to do the append but am getting errors and cannot resolve.
Also, Can step 2 and 3 be performed at the same time?
Thanks,
Wayne