SELECT INNER JOIN query from multiple AS400 data sources with ADO?

[DavidCondit]

My current Access + Excel solution:
I use an Access database to create two pass through queries. Each pass through query selects records from different AS400 data source. I then use a third (regular... not pass through) query to INNER JOIN the two tables on a common field. The records returned by this query are exported to a new Excel Workbook sheet.

My desired solution:
Return records from a SELECT...INNER JOIN query (joining the tables from their respective data sources) all from within Excel.

I know how to use ADO in Excel to return records from a single data source... but how do I return a recordset created from a SELECT...INNER JOIN of tables from different AS400 data sources? Can I somehow reference the data source of each table in the ADO Command object's SQL (the SELECT...INNER JOIN statement)?

I've spent entirely too much time searching Google for this answer! Thanks for anyone willing to help me!