You are correct. I have created two tables for the TESTPRIMARY import that are independent and only for TESTPRIAMRY.

rst.Open "tblImportTESTPRIMARY1", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
rst2.Open "tblImportTESTPRIMARY2", CurrentProject.Connection, adOpenDynamic, adLockOptimistic

I didn't post all the code. Just the record adding piece. Sorry for not giving the complete picture.