5 Replies Latest reply: Jan 25, 2011 8:40 AM by At titude RSS

From Pivot Chart, Export to Oracle Database

kmbmk

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

  • From Pivot Chart, Export to Oracle Database
    At titude

    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.

    • From Pivot Chart, Export to Oracle Database
      Deepak Kurup

      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")


  • From Pivot Chart, Export to Oracle Database
    Gaurav Khare

    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

    • From Pivot Chart, Export to Oracle Database
      At titude

       


      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.

  • From Pivot Chart, Export to Oracle Database
    Sunil Jain

    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.