Recent content by atbaranet

If Table1 and Table2 Structur the same you can use DoCmd.RunSQL "INSERT INTO Tbl1 SELECT Tbl2.* FROM Tbl2 LEFT JOIN Tbl1 ON [Tbl2].ID = TBL1.ID WHERE ((( Tbl1.ID) Is Null));" i have used it i hope it works