Saving ADO recordset to Access Table

S

Seth Fehrs

Is there any way to save/insert an ADO recordset directly
into an Access 97 table? I have resultset from a
connection to SQL Server and I would like to put it
directly into a table. Doing it one record at a time via
DAO/Jet is fairly slow -- I have a feeling ADO would be a
lot quicker, but don't know how to use it in Access 97.

TIA,

Seth Fehrs
 

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

Creating a table from ADO recordset 0
>> ADO Updateable recordset 3
Append externally sourced recordset to local access database 0
Access 2003: Bind Form To ADO Recordset? 0
help with vba altering access data 1
Checking the current ADO recordset record for a value? 2
Binding MS Access form to ADO recordset: Invalid use of property 2
ADO from Oracle to Access 2

Top