Copy ADO RST to ACCESS TABLE (MDB)

G

Greg Franke

I need to copy an ADO recordset to an Access Table.
How can this be done?

Thanks!
 
D

Douglas J Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Macro to copy table of contents to a new doc 0
Data Provider Could not be initialized 3
Changing pivot table ADO recordset 0
ADO and Form Requery 0
loop in ado rst 4
Dealing with a Pivot Table (when I don't want to) 0
Copy ADO to MDB 7

Top