Connecting a XLSB File

[#1]

Hey,

i'm already trying to connect a XLSB file to qlik sense since 2 day's. Which OLE DB connector should i use?

Can anyone help?

Best regards,

Jan

[marcus_sommer]

I use a odbc-driver like: ODBC CONNECT TO [Excel Files;DBQ=$(vFile)];

and it worked well. Here you will get more informations: Dynamically Loading Multiple Excel Files

- Marcus

[#3]

Hi Marcus,

thanks for your fast response!

Can you may show me an example? I've already read that discussion but didn't understand how to do it....

Regards,

Jan

[marcus_sommer]

Try it at first simple without the loops like:

ODBC CONNECT32 TO [Excel Files;DBQ=YourPath\YourExcel.xlsb];

YourTableName:

SELECT * FROM `YourPath\YourExcel.xlsb`.`YourSheet$`;

Necessary for it is of course to have an installed odbc-driver, see for it: The Great ODBC Confusion‌ and then you could simple connect to your file per wizard like here explained: Loading ODBC Data into QlikView.

- Marcus