Discussion board where members can learn more about Qlik Sense Data Connectivity.
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?
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
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....
Try it at first simple without the loops like:
ODBC CONNECT32 TO [Excel Files;DBQ=YourPath\YourExcel.xlsb];
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.