dynamic load of set of excel files

[alec1982]

I have a set of 10 excel files as follow

abc-10-16-2015.xlsx

abc-10-17-2015.xlsx

...

abc.xlsx

Need to load the files into one table but not include any file that doesn't have time stamp.

also within each file I have 10 tabs and each tab has the same table but for different type. the sheet name define the type.

Is there anyway I can concatinate all of them into one table and add the sheet name as column named tab?

Thxs,

Alec

[avinashelite]

Hope this document might help you

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[alec1982]

hi,

When using the solution above. it appears to create duplicates on my side..

Here is my sample files and qvw..

I couldn't figure out why the duplicates on the second file happening..

if anyone can help, I appreciate it!

Alec

[rwunderlich · Accepted solution]

You need to drop the Temp table for each loop.

NEXT i

DROP TABLE Temp;

Next

Without the DROP, you are adding to the table each time you issue SQLTABLES.

-Rob

[alec1982]

thank you Rob!