When running the code, have it add the records to this empty table, then
One of the most frequent questions I receive is about queries that won't update data.
SQL Query for Serial Number – Community Archive
Create a DAO Recordset From a Query – msdn.Microsoft.Com
Cannot add record(s); join key of table " " not in recordset
In this blog post we will be showing you how to update, add and delete records in a recordset.
Excel – Handling AddNew Key Violations ADODB.Recordset