I need to copy an ADO recordset to an Access Table. How can this be done? Thanks!
G Greg Franke Apr 11, 2006 #1 I need to copy an ADO recordset to an Access Table. How can this be done? Thanks!
D Douglas J Steele Apr 11, 2006 #2 I think the only way is to loop through the recordset row-by-row, and then either append it to a second recordset opened on the table, or else generate an INSERT statement and run the SQL.
I think the only way is to loop through the recordset row-by-row, and then either append it to a second recordset opened on the table, or else generate an INSERT statement and run the SQL.
