Add 2 Recordsets

[vbjohn]

Is there a way that you can add 2 recordsets together into one?

I have to get records from 2 different databases and put them together into 1 report.


John-

 

[Creepers]

My first reaction was to write a union query, however this will not work because tables belong to two different databases, i.e. two different connection strings.
You could but both tables into one disconnected recordset.
You could also create a temporary table in one of the databases.

 

[garths2]

FYI:

There is a product called "Data Connect by Attunity" It allows you to do a single SQL query against multiple data sources. Reasonably cheap for what it can do.