From Pivot Chart, Export to Oracle Database

[#1]

Hi,

I am looking to export the pivot table using macro to Oracle Database. Let me know how this can be done.

Thanks in advance.

Bala

[#2]

Hi Bala

I am also looking for something similar to this only. I want to export the out of a qlikview data to the database.

Did you got any solution for this. If you have any solution please share with me please.

[deepakk]

hi,

you can search for VB codes and use it in macro. Something similar to below. I had done this in a small way. But currently doesn't have the exact codes. but I think you can start of your search from below codes and let me know if you guys need any help on the same.

connection = CreateObject("ADODB.Connection")Set rows = CreateObject("ADODB.Recordset")

[gauravkhare]

hi kmbmk,

not to sure about your query but i feel that this can be achieved by going to expreesions and then to representation and then we can assign a link to dynamically upload/export the data from qlikview to some other db.

the above is one possible way to achieve your requirment. Kindly let me know about the solution. I will be following your query.

Regards

Gaurav

[suniljain]

This task is possible only through internediate place. you can export pivot table in CSV or Excel and then import that excel or CSV in database whether its sequel or oracle.

I think it is not posisble through the way suggested by others in this post.

[#6]

Gaurav wrote:
not to sure about your query but i feel that this can be achieved by going to expreesions and then to representation and then we can assign a link to dynamically upload/export the data from qlikview to some other db.
the above is one possible way to achieve your requirment. Kindly let me know about the solution. I will be following your query. <div></div>

Could you please attach any sample application which does the same.