I need to know how to set an excel range as a recordset so I can write some sql queries, then transfer my query results to another excel file for reporting. I know how to do step 2, just need to know how to setup the excel file/range as an ODBC source I guess.