Inner Join 2 Excel Sheets with ADO?

[stanl]

Any pointers will be much appreciated....

I don't see 2 separate sheets in your code - same source file, same Sheet1$

but assuming exelfile_2 has Sheet1$ and Sheet2$ that need to be joined, why not open the cConn = CreateObject("ADODB.Connection") then just run your SQL through cConn.Execute mySQLStatement

.02 Stan