Extract info using Shape

A

Al

I'd like to consolidate information from two recordsets
using Shape.

Recordset #1 is taken from an IBM DB2 database.

So lets say thats the customers table.
Primary key is customerid

Recordset #2 is taken from an Oracle Database.

So lets say thats the orders table.
foreign key is customerid

I can extract both tables successfully separately,
but is it possible to extract information from
both recordsets in one step using the ado Shape
command?

What I have been doing is extracting both tables
to an Access database and then joining the two
tables. Just looking for a way to do things
more efficiently and increase my knowledge.

Thanks in advance.
 

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

VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Prevent Duplicate Records in table with multiple Fields as Primary 7
Dealing with unparseable records 4
Where is getstring? 6
Extracting Mailboxes using Macros as in Pivot table? 1
Single Front End with multiple Back Ends 5
return code with maximum RVU 2
DAO & ADO within the Same Application? 1

Top