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.