Qlikviwe ODBC in Excel

[#1]

Hi all,

I am trying to show Qlikview-Data in Excel (2010).

For this I installed Qlikview 8.5 because of the ODBC driver.

Now I wanted to extract some data out of my Qlikview-App. So I made a new ODBC-Data Source in my Win7. In Excel I tried to open that connection (ODBC DSN) via the Excel menue "Connections". I found that Connection in the following menue but I got the exception :

No Tablelists could be found on that data source  (or sth. like that because I use the german version...

Can anyone explain me how I can extract data like that?

Thank you in advance!

Regards,
Michael

[#2]

mich,

I think you are asking how to query from excel.  Here is an example from what I use.

LOAD EMPLOYEENUMBER,

     MONTH,

     MARGINQUOTA,

     REVENUEQUOTA

FROM

C:\QlikViewReports\Sourcedocuments\DataFiles\Quota.xlsx

(ooxml, embedded labels, table is Sheet1);

Note the syntax where the table is Sheet1.  Sheet1 is the name of the excel worksheet tab.

Nothing was required in terms of ODBC as I was simply querying from an excel file in a directory on the same server.

Kal

[#3]

Hi Kal,

this is not the way I want to do it. I want to do it totally the other way round. I want to load a table from Qlikview in Excel to work with it as a pivot table in Excel

What you explained is the normal Excel-load in Qlikview

Greets