topic Re: Connecting a XLSB File in Connectivity & Data Prep

Connecting a XLSB File

Wed, 15 Feb 2017 14:40:34 GMT

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 — Wed, 15 Feb 2017 17:23:36 GMT

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

Thu, 16 Feb 2017 07:35:41 GMT

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 — Fri, 17 Feb 2017 10:00:08 GMT

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