≡ Menu

Import Export data: Excel Add-ins with AIF service Dynamics Ax 2012

 

If you set up Aif service data in Dynamics Ax 2012, You can easily import and export data into AX using Excel Add-in.  You can export, import data with all out of the box AIF services.  In the case of table import export in Excel add-ins then under the hood AIF metadata service used.

 

For current post I am using my exists custom document Service in Excel Add-ins. The more complex custom services can be written.

This custom service is in detail you can follow following article.

http://tech.alirazazaidi.com/creating-and-consuming-custom-document-service-in-dynamics-ax-2012-r3/

 

  • Setting up data source in Ax for Excel Add ins

ddddeeeee

 

11-25-2014 3-21-48 AM

 

 

 

Now click open the Excel and create a new worksheet. You find Dynamics Ax  tab strip as follow

11-23-2014 10-26-45 PM

 

Click  and open the connection to Dynamics Ax 2012

11-25-2014 3-23-40 AM

 

Now click on add data at tab strip and click add data

11-25-2014 3-24-16 AM

 

Select the source

11-25-2014 3-24-39 AM

Now drag and expend it to required number columns.

11-25-2014 3-32-50 AM

11-25-2014 3-34-11 AM

 

Second way to select the header and click on add row button  from Dynamics AX tab strip.

 

11-25-2014 11-12-20 AM

Enter data and click on publish button. After pressing the publish button open table explorer in AOT, data is found.

 

11-25-2014 3-47-51 AM

 

 

 

 

 

 

{ 0 comments… add one }

Leave a Comment