[RESOLVED] How To Use Excel File/Range as Recordset and Run SQL on it
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.
Re: How To Use Excel File/Range as Recordset and Run SQL on it
Re: How To Use Excel File/Range as Recordset and Run SQL on it
Awesome, thanks for the quick reply, exactly what I need to make my life easier!! I knew it could be done. Now I won't need to import the worksheet into Access anymore.
