How to join two record sets from different DB using vba

[sreenivast]

I have an requirement that retrieving the data from two different data bases.
I want to compare those two and prepare a report using VBA.
I am able to get the data to excel separately, but now I need to join these two sets based on the key columns

Thanks,
Sreenivas

[JosephP]

can you import one table into the other database? you may be able to join them in code to create one recordset but you haven't provided any real information yet ;-)

[Norie]

You should import or link the data from one database to the other.

You can then use a query to link tables etc and, if you need to, then export the results to Excel.