Load data from multiple sheets from single excel file and store each sheet into QVD dynamically

[Qlikuser225]

Hello All,

I am trying to load data from multiple sheets from single excel file and store each sheet into QVD dynamically.

i am using below code

FOR EACH file in FileList('lib://Qlik/*.xlsx');

//In order to get the file information from SQLtables command making use of the ODBC connection format
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];

tables:
SQLtables;
DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
Table:
Load * ,
FileBaseName()as FIle,
FileDir() as Dir,
FileName() as File_Name,
'$(sheetName)' as Sheet_name
From $(file)(ooxml, embedded labels, table is [$(sheetName)]);

NEXT i

Next

I am getting connection not found error at ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];

Can you please help me to understand what does "ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];" do and how to create one in my Qlik sense app.

Thanks in advance

[Vegar]

The command ODBC CONNECT32 TO [Excel Files;DBQ=$(file)]; tried to connect to your excel using an ODBC connection on the machine that is running the script.

I guess you will need to have an Excel odbc driver installed fot that command to work.