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.