topic How to export the qvw data to other database (Excel\SQL)? in QlikView

How to export the qvw data to other database (Excel\SQL)?

Wed, 26 May 2010 08:02:49 GMT

Hello friends,

I am working with qlikview and have a requirement of using some qlikview data in my other application which can fetch data from EXCEL and SQL? How can i do this? ( I know a way by using button and exporting in txt/csv format) Looking for a direct interaction of qlikview and SQL/EXCEL.

How to export the qvw data to other database (Excel\SQL)?

TK_ — Wed, 26 May 2010 11:33:34 GMT

In QV 10 it is possible to store tables in the script to csv-files. Maybe that will be helpful?

regards

Terje

Re. :How to export the qvw data to other database (Excel\SQL)?

martin59 — Wed, 26 May 2010 11:35:49 GMT

Hi,

In QV9 you have to do that :

STORE MyTable INTO MyTable.csv (txt);

How to export the qvw data to other database (Excel\SQL)?

Wed, 26 May 2010 11:48:44 GMT

Hi,

Sorry Terje i couldnt understand what you said... could you plz explain it in bit detail how can i do that?

How to export the qvw data to other database (Excel\SQL)?

Thu, 27 May 2010 06:22:41 GMT

Hi,

I was trying what was suggested by a friend Martin but problem is i coudnt get the name of the table name for qlikview file.

How to get the name of the table where qlikview store the data after importing.

Re. :Re: How to export the qvw data to other database (Excel\SQL)?

martin59 — Mon, 31 May 2010 13:37:46 GMT

You can rename your table like this :

MyTable:
Load *
FROM ....;

Otherwise, if it's an excel file, the table name must be ExcelTabName$.