Insert Vendor data from text file to AX 2012


I have one text file that contains AccountNum, Name, Address & invoice account.
Currently have 8678 vendor on my txt file.

My question is. How to I import this all vendor data to AX 2012 and what table that related to Vendor

anybody can help me?

Hi Muhd,

I can think of have following options for you-

  1. Bespoke - writing code for importing vendors from your text file. If you decide to go down this route, I would suggest using AIF for creating vendors.

  2. DMF - Data Migration Framework is another option. Using the latest version (2.0 I believe) it is possible to import vendors from disparate sources. This tool is available from InformationSource website. I also posted another link to download in one of my posts.