I need to open an ADODB connection with an excel file so I can query the information contained in it. I do this using the following connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";

I also need information from a SQL table which I get using the following

Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;
Once I have information from both, I need to do a join of the 2. However, I have no idea how to accomplish this. I was hoping there would be a way to query the excel file using the SQL connection string as well but that doesn't seem to be possible. I have also thought about opening the excel file and inserting it into a temp table in SQL but from what I understand I would have to do a massive loop as the records would need to be inserted one by one. I would prefer to do this the cleanest way possible.

Has anyone attempted this before or have any ideas?

Thanks