Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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