You can create 3 queries to get the relevant records and then change them to append queries to append them to the relevant tables.
- SELECT tblNew.*
-
FROM tblNew INNER JOIN tblOld
-
ON tblNew.Name = tblOld.Name
This will give all records that are the same in both tables
- SELECT tblNew.*
-
FROM tblNew LEFT JOIN tblOld
-
ON tblNew.Name = tblOld.Name
-
WHERE tblOld.Name Is Null
This will give all records present in tblNew but not in tblOld
- SELECT tblOld.*
-
FROM tblOld LEFT JOIN tblNew
-
ON tblOld.Name = tblNew.Name
-
WHERE tblNew.Name Is Null
This will give all records present in tblOld but not in tblNew
