Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

.xlsb ODBC connection QlikSense

Dear Qliksensers,

I created an ODBC connection to a .xlsb (Excel Binary) but it didn't show any tables/workbooks. What did i do wrong?

10 Replies

Hello Michal, Community,

I need to load multiple xlsb files to Qlik SENSE.

I use the Microsoft Excel ODBC Driver as shown in above screenshots.

With the above driver, I HAVE TO select a SINGLE xlsb file as database. Eg. Test_01.xlsb

Connect - Load - Disconnect, ok

Now I select another xlsb file (Script editor, Select Data, Select a Database, E.g Test_02.xlsb

Connect - Load - Disconnect , ok

However, if I want a LOOP load of the files, I cannot specify the FROM statement:

  • FROM `$(vFileName)`.`'Sheet$'`;  DOES NOT work – the synthax is exact copy of the from statement the data load editor inserted
  • In the loop, it only loads from original FROM Statement of the single file: FROM `C:\...\..\Test_01.xlsb`.`'Sheet$'`;

  • If – for test reason – I run the loop from the fixed „long” FROM statement (FROM `C:\...\..\Test_01.xlsb`.`'Sheet$'`; ) – it reads from the same file, as expected
  • If – for test reason – I run the loop and specifiy Test_02.xlsb in the „long” FROM statement (FROM `C:\..\..\Test_02.xlsb`.`'Sheet$'`; ) – it still reads from Test_01.xlsb file

In the loop. I do use Connect and Disconnet,

Connect is like this: LIB CONNECT TO 'Excel Files';

But to the contrary of ODBC Connect in QlikView, I cannot specify nowhere in the loop the database e.g. the xlsb file

(QlikView: ODBC CONNECT32 TO [Excel Files;DBQ=$(vFileName)];) This does not work in Sense

So can you guys help with how to load MULTIPLE xlsb files to SENSE? Thanks a lot!