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

[#1]

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.

[TK_]

Hi

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

regards

Terje

[martin59]

Hi,

In QV9 you have to do that :

STORE MyTable INTO MyTable.csv (txt);

[#4]

Hi,

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

[#5]

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.

[martin59]

You can rename your table like this :

MyTable:
Load *
FROM ....;

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