How to get data from xlsb to QlikView

[Anonymous]

I have a .xlsb (Excel Binary File) , I need data from this file in QlikView

[mjayachandran]

if data from this file format has to loaded in Qlikview, we can not do with the help of "File Wizard", but for that we need to create a ODBC/OLE DB link to load the data.

See this thread

Loading Excel Binary File into Qlikview.

[Anonymous]

Hi,

Thanks for your replay , can u describe the steps to create ODBC connection.

I am a beginner in QV so please...

[fkeuroglian]

See this, hope help

Fernando

Loading ODBC Data into QlikView - YouTube

New to QlikView: Load Data from ODBC - YouTube

Creating ODBC Connection

Axiom Semantics: How to connect Oracle tables from QlikView using ODBC?

[mjayachandran · Accepted solution]

Its easy,

1. Make sure Excel ODBC drivers are installed. It install by default most of the time while installing Office.

2. Go to Administrative Tools -> Data Sources (ODBC) -> Choose User DSN -> Choose either 'Excel Files'from the list -> Press 'Configure' -> finally choose the file as ODBC source

Once the connection is addded successfully, In QV script editor you can select the odbc connection

[Anonymous]

Thank a lot...

[mjayachandran]

You are most welcome..