Solved: Re: Loading Excel Binary File into Qlikview. - Qlik Community

kaushiknsolanki · ‎2011-03-25

Hi Everyone,

I want to know Whether it is possible to load data from Excel Binary Worksheet which has .xlsb File format, into QlikView...

If it is possible please let me know the way in which it can be achieved....

Thanks..

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-03-25

It is possible by creating a new ODBC connection, using "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)", to the file. Then using that ODBC-connection in QlikView.

View solution in original post

Report Inappropriate Content · ‎2011-03-25

It is possible by creating a new ODBC connection, using "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)", to the file. Then using that ODBC-connection in QlikView.

kaushiknsolanki · ‎2011-03-25

Thanks Robin for your quick and valuable help..

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

manojkulkarni · ‎2017-09-27

Hi Kaushik,

How do you handle if Excel drivers not installed ? Normally in production architecture Office will not be available in server ?

marcus_sommer · ‎2017-09-27

Maybe you could outsource this job to another machine/system whereby why not installing office/excel or at least the database-driver (I could imagine that they are independently available)?

Of course I have heard statements from the IT guys that "a server is a server and no office belonged to them" but in my opnion it's not very responsible and cooperative - it's just a normal business requirement and from a security point of view no special risk especially compared with normal challenges to secure the environment.

- Marcus