Loading Excel Binary File into Qlikview.

[kaushiknsolanki]

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..

[#2 · Accepted solution]

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]

Thanks Robin for your quick and valuable help..

[manojkulkarni]

Hi Kaushik,

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

[marcus_sommer]

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