ado recordset as source in DoCmd.TransferDatabase

B

Bruce Hensley

Using VBScript, I am trying to create a new table in an Access database
based on an ADO recordset obtained from an Oracle database.

Is it possible to use an ADO recordset as the source for an imported table
using DoCmd.TransferDatabase? If so, can you give me some help with the
syntax? (I've been searching for 2 days.)

Is there another expedient alternative?

Thanks!

Bruce
 
D

Douglas J. Steele

I don't believe it is possible. I think you need to loop through each record
in the recordset, and write it to the new table.
 

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

copying recordset to Access table 1
>> ADO Updateable recordset 3
Import File Information 0
Creating ADODB recordset in code 8
Really slow procedure A2007 ADO 3
Bind ADO Recordset (filtered) to a Listbox 1
Need Help getting current key value after adding ADO record in SQL 1
ADO recordset as record source 6

Top