I have to load all excel files into a table.
now the issue I am getting is that the file name is always going to be different no matter what and the same goes for the sheet. Is it possible to setup the toad automation to just load the all excel files using the first sheet regardless of its name as it will also be different. that way once it is done I want to move the excel files to a separate location.