You need to do the join in the sql statement that creates the records set -
rather than creating two recordsets, create one recordset doing the join in
that sql statement.
--
Regards,
Tom Ogilvy

"PO" <po wrote in message ...
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