How to import Master Data into AX 2012

Hi all,

I want to Import Master Data into AX 2012. I want to prepare Data Templates in excel for Customers, Vendors and other masters. I am facing problem in the choosing the tables and fields for the respective Masters.

Can any one help me in this regard.




You can go through the below site which will help you understand the master data import in AX 2012.


Vishal :slight_smile:

Nice, but I would still recommend the DMF solution provided by Microsoft that is designed for Data Migration whilst the Excel add-in is not really.

Hi Manju,

This subject was discussed so many times at great lengths here. Please look up for them here.

By using excel add ins it is highly difficult to import masters data. Data migration tool is available in partner source. By using this you can import all masters data .I’m also using this tool in production environment with out any problem.

Hi Michel,

Can you share some information/documentation on this? It would be great if you can provide me the process document.

PDF’s are not available for this tool.

Hi Michal ,

Thanks for the link.

I am also looking for same kind of tool .

Can you explain in detail , how to use this tool and how to import the data ?

Thanks in advance.

Please go through the above link.