How to create ODBC CONNECT32 TO [Excel Files;DBQ=$(file)]; in Qlik Sense

[Qlikuser225]

Hello All,

Can anyone please help me to understand how to create a ODBC connection in Qlik sense.

I am trying to load multiple sheets from excel files and it requires a command below command. 

"ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];"

When i try to load it gives me an error saying " "CONNECTs other than LIB CONNECT are not available in this script mode" and error occured at ODBC Connect32 **.

Thanks in advance

[Sebastian_Linser]

Hello @Qlikuser225 

the way with LIB CONNECT was shown here https://community.qlik.com/t5/App-Development/how-to-connect-to-Excel-with-ODBC/td-p/1567109

best regards

Sebastian