topic Re: How to get data from xlsb to QlikView in QlikView

How to get data from xlsb to QlikView

Anonymous — Mon, 06 Oct 2014 09:19:20 GMT

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

Re: How to get data from xlsb to QlikView

mjayachandran — Mon, 06 Oct 2014 09:25:22 GMT

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.

Re: How to get data from xlsb to QlikView

Anonymous — Mon, 06 Oct 2014 10:00:47 GMT

Hi,

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

I am a beginner in QV so please...

Re: How to get data from xlsb to QlikView

fkeuroglian — Mon, 06 Oct 2014 11:33:21 GMT

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?

Re: How to get data from xlsb to QlikView

mjayachandran — Mon, 06 Oct 2014 11:56:56 GMT

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

Re: How to get data from xlsb to QlikView

Anonymous — Mon, 06 Oct 2014 12:59:49 GMT

Thank a lot...

Re: How to get data from xlsb to QlikView

mjayachandran — Mon, 06 Oct 2014 13:03:00 GMT

You are most welcome..