I am trying to run an insert into from one table to the second table. For some reason, I think it does not like the "not in". Here is the code. It does not give an error it just spins Currently there are about 40 records it is trying to insert. I also tested with just a select statement and it does the same thing.
Code:
Dim db As Database
Set db = CurrentDb
db.Execute "INSERT INTO all_matters (RowID, Client, Matter, ClientName, MatterDescription, OpenedDate, ClosedDate, OriginatingAttorney, BillingAttorney, MatterType, ClosedFile1, ClosedFile2, Years, Notes, DestructionDate, ProposedDestructionD) " & _
" SELECT RowID, Client, Matter, ClientName, MatterDescription, OpenedDate, ClosedDate, OriginatingAttorney, BillingAttorney, MatterType, ClosedFile1, ClosedFile2, Years, Notes, DestructionDate, ProposedDestructionD " & _
" FROM all_matters1 WHERE all_matters1.RowID NOT IN (SELECT all_matters.RowID FROM all_matters); "