Hi,

I want to join data from 2 different databases in one table and then put the
merged data in a spreadsheet.

I use 2 recordsets to get the data:

RS1 contains the following data: SELECT CustomerID, Name, Description FROM
Table X (in DB1)
RS2 contains the following data: SELECT CustomerID, Adress, Description FROM
Table Y (in DB2)

I now want to join RS1 with RS2 and put the result in RS3.

I suspect you could do something like this(?):

RS3.RecordSource=
SELECT
RS1!Name, RS2!Adress
FROM
RS1, RS2
WHERE
RS1.CustomerID=RS2.CustomerID

but I don´t know exacly how to do this.

Kind regards!

Peter Osswald