SQL join tables across multiple ADO Connections

[In_the_CLE]

In VBA, I would like to perform an SQL join of tables from two different ADO Connections. Is this possible ? The syntax of the ADO Recordset Open method seems to suggest it works on just one Connection. But if there is some way to do this, I would be grateful if someone could post a sample. One connection might be to an Access database, another to SQL server, for example. Or Oracle. I can make the multiple connections inside the code. Just don't know how to join the tables into a single SQL query. I know a fallback could be to load the data into arrays and work with them that way, but if there is a way to join the tables, that would be great. Thank you for any suggestions you may have.

[ranman256]

if you link the tables via odbc ,then you can just build a query and join them, since they appear as a table.

[In_the_CLE]

Thanks, ranman256. I am trying to do this inside VBA, not in the Access GUI. I'm not sure how to do what you suggest inside VBA.