Inner Join 2 Excel Sheets with ADO?

[stanl]

Thanks Stanl, but the data needs to come from two separate files.

I think you are confusing a file with a sheet. In the two Provider Strings you gave in your initial code you have

Data Source=exelfile_2.xls

that is a file, both strings reference the same file. Then since you only reference Sheet1$ that to me was the same file and the same sheet - hence my confusion. If the data does, as you say, have to come from two files, they both cannot be named exelfile_2.xls.