QlikSense LIB Connect error with SQLTables Function for Excel sheets
I recently asked a question about concatenating multiple sheets in the same Excel spreadsheet. There is no sequential/logical filename and i have been provided with a few ways to do it using SQLTables to get a list of sheet names and then a for next loop to put it together.
BUT, my problem is not the solution to my excel issues, it is the ODBC Connection. I'm getting the error;
The following error occurred:
CONNECTs other than LIB CONNECT are not available in this script mode.
We are using QlikSense Enterprise and the speadsheet is on our enterprise server. I don't know much about connections and don't know much about SQLTables as a function.
The question is, what do i need to do to resolve this error and create an ODBC connection to the excel sheet. Maybe i'm not making sense as this is new to me but any help would be greatful. Thanks Qliktopians
Thank you for this. I already pull from a SQL database, and i've pulled from excel files. I have just never pulled from an excel file from multiple sheets.
Some of the solutions people gave me to pull all the sheets in the excel file was to use a script that uses the function SQLTables and an ODBC Connection to the excel file. I think SQLTables is a function that lists the sheetnames via the ODBC connection - so i need to start by fixing/creating this connection before using the excel sheets script from other threads
I will try and create the connection, wish me luck
We are running Windows 2016. This server does not have a ODBC driver for xlsx files. Searched Microsoft and can not seem to find the correct driver. Can you advise how we get this driver, or have I gone down the wrong track?