How do I use 2 ADO connections in one query?

[tallman64]

Hello,

I have a situation where i have need 2 connections (one to Excel and one Access) to create a recordset.

I have no trouble querying these two sources separately. Typically I use a statement such as the following:

...
rsRecordset.Open strSQL, cnExcel, adOpenStatic, adLockReadOnly
...

in my new situation, strSQL requires field names from 2 sources i.e.

(from Access SQL view)

SELECT Tables.Business_Unit, Count(Database.CL) AS CountOfCL, Sum(Database.[EXT QT]) AS [SumOfEXT QT]
FROM [Database] INNER JOIN Tables ON Database.CL = Tables.Class
GROUP BY Tables.Business_Unit
ORDER BY Sum(Database.[EXT QT]) DESC;

where "Tables" is an MS Access source and Database is an Excel spreadsheet.

Can someone help me bark up the right tree?

thanks in advance,

Chris