Dump data straight into Access database table from ADO recordset

billgates
04-14-2004, 05:41 AM
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.

Shurik12
04-14-2004, 06:30 AM
>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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum