Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Connecting a XLSB File

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

Tags (1)
3 Replies

Re: Connecting a XLSB File

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

Not applicable

Re: Connecting a XLSB File

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

Re: Connecting a XLSB File

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

Community Browser