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
Now click open the Excel and create a new worksheet. You find Dynamics Ax tab strip as follow
Click and open the connection to Dynamics Ax 2012
Now click on add data at tab strip and click add data
Select the source
Now drag and expend it to required number columns.
Second way to select the header and click on add row button from Dynamics AX tab strip.
Enter data and click on publish button. After pressing the publish button open table explorer in AOT, data is found.