need to load all the sheets in excel at time ?

[#1]

HI All,

I am having months data in the Excel Sheet.

Every month it will added one more Sheet With new month, need to be loaded in a Single load dynamically.

Please find the attached excel, Can any help me on this..

Regards,

Helen

[effinty2112]

Helen,

Let vXLSPath='PathToFileIncludingFilename.xlsx';

ODBC CONNECT TO [Excel Files;DBQ=$(vXLSPath)];

     Sheets:

     SQLTABLES;

     DISCONNECT;

for i = 0 to FieldValueCount('TABLE_NAME') -1

Let vTablename = Left(Peek('TABLE_NAME',$(i)),len(Peek('TABLE_NAME',$(i)))-1);

Data:

LOAD *

FROM

$(vXLSPath)

(ooxml, embedded labels, table is [$(vTablename)]);

Next i;

DROP Table Sheets;

[alextomlins]

Hi Andrew Walker - I'm getting an error for the ODBC connection. I'm on Qlik Sense Enterprise....Do you know what it could be out of chance? ;

The following error occurred:

CONNECTs other than LIB CONNECT are not available in this script mode.