1 Reply Latest reply: May 15, 2014 9:56 AM by Viv _ RSS

    Export to SQL Server

    atma _

      I have data coming in an excel sheet which i need to export to SQL server. Is there a way this can be done using Monarch?

      I know Monarch exports data to Access database but I need to export to SQL server.

      I am using Monarch Pro V7. I would appreciate any help in this regard.

        • Export to SQL Server
          Viv _

          I think you need Data Pump version 7 for this. It comes with a project editor utility that allows you to export data to SQL Server tables, and schedule those updates.

           

          However, alternatively, you could manipulate / export the data using Monarch and use SQL Server DTS to import the data to SQL Server, afterwards.