Loading XLSB file format into Qlikview

[tamilarasu]

                We have multiple xlsb format files and I want to load all of them in a single table. I have created ODBC connection but I can not find similar thread on how to load multiple files in single table.

Kaushik.solanki‌  I just see your threads regarding the xlsb format issue. Do you have any idea about this.?

Thank you in advance.

[#2]

Script Error: Did not recognise connector reply SQL SELECT * From ********

[dbodders]

Great solution as I am loading xlsb files from SharePoint folders and have complexities around connections thrown in for good measure.

One thing that caught me for a while was the SELECT/SQL statement was failing. I was using dymanic file names and the apostrophes around the file name and sheet name were the wrong apostrophe.

I was using ' but needs to be ` - chr(96) rather than chr(39).

Hope this saves someone else the hour or so I spent trying to sort it!

[SB2021]

Hi 

You can load the .xlsb files through  sharepoint  0365 connectors (QlikWebConnector )

Load *

From [<sharepoint connector>] 

(txt, utf8, embedded labels, delimiter is '\t', msq);

the part "(txt, utf8, embedded labels, delimiter is '\t', msq);" will be same  as the file is loaded in the  .csv  format.