Data importing from excel to ax2009

Finance and Operations/AX Technical Forum
1

Hi,

In ax2009, Legacy data importing process. one record only importing in ax Table. i have 65530 records. i want import all data. tables are customized

any one can help me please urgent…

2

What method are you using for the import? A script you have written I presume?

3

am not use any method. i followed standard process…

4

Hi,

Please follow the following steps:

  1. Create an excel template of the table you have created.

Administration > Periodic > Data export/import > Excel spreadsheets > Template wizard

  1. Check (Tick Mark) on Create import definition group while creating template.

  2. Paste your data (1000-2000 records otherwise it will take a lot of time) in that file.

  3. Import that file.

Administration > Periodic > Data export/import > Excel spreadsheets > Microsoft Office Excel Import.

  1. Follow steps 3 and 4 for rest of the records.

Regards,

Mayank Bajaj

5

I am still using Microsoft office 2007 version. Can you guide me how to do the same job in this version?

6

Hi,

AX 2009 supports all office versions (2000, 2003, XP, 2007 and 2010) and the steps for all are same as mentioned in the solution. The only thing is that you should use same office application for import and export. In the first sheet of the template which is #DEF, AX specifies the Excel version in it.

Regards,

Mayank Bajaj