Re: Dynamically Loading Multiple Excel files and sheet in subfolder
without the ODBC connection
You need the odbc connection to get a list of the sheets in an excel file. If you have an alternative way to get the list of sheets for each excel file then you can use that instead of the odbc SQLTABLES function. Otherwise you're stuck with ODBC.