How to load data from SharePoint.

[jsingh71]

Hello Everyone,

In my application I am pulling data from Sharepoint URL. There are 5 excel files available in this url.

All files having the different name but same structure means same tab name and column name.

When I am loading single excel file then data loaded sucessfully,

for example:

                         LOAD

                              Field1,

                              Field2

                         FROM

                              [https://sharepoint.mydomain.com/files/abc.xlsm]

                                   (ooxml, no labels, table is [sheet_name];

This is working fine without any issue. but when I try to load all the excel file using below code:

                         LOAD

                              Field1,

                              Field2

                         FROM

                              [https://sharepoint.mydomain.com/files/*.xlsm]

                                   (ooxml, no labels, table is [sheet_name];

Then its showing error message "bad zip file", Can any one please share the solution to avoid this error.

Thanks in Advance.