That Line did not confuse me. What is confusing me is the Idea of 1000 at a time when you could do
Insert Into [TBL1] (Field1, Field2 ,Field3 ,Field4,Field5)
Select Field1, Field2 ,Field3 ,Field4,Field5 From [TableName of rst_RS]
But now I see that you have two different DB's.
Have you...