(Eng) Use AML Query to Export data in Excel

Posted on February 16, 2012

This is once again a nice tip we are happy to share to the whole community. It is pretty simple but usefull as soon as you want to extract informations from your Aras Innovator database in order to play with it in an Excel Spreadsheet. We know Microsoft Excel is your favorite playground (at least it is for 100% of our customers and prospects) and we here your request everytime to make it easier to export informations to Microsoft Excel. So just by curiosity, we’ve made some test with a tool we’ve already made presentation about which is the AMLstudio (available for free on its codeplex page). We knew that Microsoft Excel had some advanced features regarding XML data. So we setup the AMLStudio to export the results of its queries to Microsoft Excel and here is the result in the following video.

 

 Yoann Maingon

Anthony Ponceot

Anthony Ponceot is an Aras Innovator Expert

More Posts

Follow Me:
Twitter

  • Ken

    How can I export the results by using new version 2.0 ?
    In the version 2.0, I can’t find the “Display Response” button on the screen.

    • Hi Ken, I don’t think you can do the same thing then in the first version. You can still copy paste your result to xml notepad for example. If you want version 1 is still available on the codeplex page.
      I still use version 1.

      • Ken

        Hi Yoann, Thanks for your quick reply. OK, I see. Although it requires some additional work, I’ll save my xml results to local disk first, and then import it into Excel. I can use version 1.2 in conjunction with version 2.0 either.

Download Aras Innovator