ado recordset as source in DoCmd.TransferDatabase

  • Thread starter Thread starter Bruce Hensley
  • Start date Start date
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
 
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.
 
Back
Top