Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Have a look on postings like that: Loading Multiple Excel Sheets Dynamically along with file name and sheet name.
- Marcus