Dump data straight into Access database table from ADO recordset

Dump data straight into Access database table from ADO recordset

I'm fairly certain this can be done straight from an ADO recordset (in VB) but I'm not sure how.

I know that it can be done by looping through the whole recordset and executing n SQL INSERTs.

>I know that it can be done by looping through the whole recordset and executing n SQL INSERTs.
...Or by doing something similar to:


"INSERT INTO Table1 (Field1, Field2, Field3)
SELECT Field1, Field2, Field3
FROM Table2
WHERE Field1='bla' "


(where the SELECT statement is your recordset)

Regards,
Shurik.