Inner Join 2 Excel Sheets with ADO?

[stanl]

You have to create 2 separate connection objects, one for each worksheet you want to open. Then you need to create 2 separate recordset objects, one for each worksheet.

In my experience you don't. An individual .xls file can be treated by ADO as a database and each sheet, or named range as a table. Therefore, a single Connection to the file can process information from multiple sheets in that same file. And from another perspective, data from multiple tables (say in Access) can be SELECTED or INSERTED into multiple sheets on the same xls file with a single connection. .02 Stan