Apend ADO recordset to local table

S

Simon Morley

Having sourced data from Sybase tables into an ADO recordset, I need a way to
apend the data within that recordset into a local table, but would like to
avoid looping through the recordset transferring each record field-by-field
(because life's too short!) I'm really hoping that there might be something
like the CopyFromRecordset member of the Range class in Excel, but I can't
find anything that obvious. Any ideas?

Many thanks,

Simon

PS The reason for this is that I may have to stop using my ODBC linked
tables which had served their purpose up to now.
 

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

Changing pivot table ADO recordset 0
Append externally sourced recordset to local access database 0
Creating a table from ADO recordset 0
CopyFromRecordset with Filtered ADO recordset 2
testing ADO recordset for PrimaryKeys 1
local recordset in acess 2
Using ADO recordset as combo box row source gives "id is invalid" 1
how do i import data into access from a AS400? 0

Top