Multiple Excel sheets without ODBC/OLEDB connection

[vardhancse]

Hi,

Can any one please let me know option to load multiple excel sheets(Having multiple sheets) with out using ODBC connection

[vardhancse]

Hi Kushal,

thank you so much, in the provided sample excel files the sheet names are like sheet 1, sheet 2....

But in my excel workbooks, my sheet names are like

20012015-20022015

20032015-20042015

[Anil_Babu_Samineni]

Then Use 20 instead of sales on your load statement which provide Kushal ?

[vardhancse]

Thank you

the sheet names mentioned above are for sample.

all the time the sheet names will not start with 20.

It might be any thing like 300616-310816, 010916-011016...so irrespective of the sheet names need to load all the data and concatenate

[vardhancse]

Hi Nagaraj,

Thank you so much

Now in our server we got the excel driver and using your if condition

If(WildMatch(vSheetName,'*$')) Then
LET vSheetName = Replace(Replace(Peek('TABLE_NAME', $(i), 'tables'),'$',''),chr(39),'');

My issue "_xlnm#_FilterDatabase" is resolved and now able to load multiple excel workbooks and sheets using ODBC

Once again thank you so much