Loading the same files with different table's names - XLSX Files

[#1]

I have to load a lot of tables from excel (xlxs) files (File_1, File_2 etc).

Each month there's a new file. In order to load all files at once, I use the character "*" before the file name's end.  Something like this:

FROM

[File*.xlsx]

But recently, the table's name has changed sometimes. 'Table_No' instead of 'Table_Yes', for example.

Today, the only way to correct this here is renaming the tables in the files source.

But it takes a lot of time, considering that we have dozens of files monthly.

How can I do this through load script, considering that I use the character "*" before the file name's end in the script?

Thanks!

[marcus_sommer]

Have a look on postings like that: Loading Multiple Excel Sheets Dynamically along with file name and sheet name.

- Marcus