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…
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…
What method are you using for the import? A script you have written I presume?
am not use any method. i followed standard process…
Hi,
Please follow the following steps:
Administration > Periodic > Data export/import > Excel spreadsheets > Template wizard
Check (Tick Mark) on Create import definition group while creating template.
Paste your data (1000-2000 records otherwise it will take a lot of time) in that file.
Import that file.
Administration > Periodic > Data export/import > Excel spreadsheets > Microsoft Office Excel Import.
Regards,
Mayank Bajaj
I am still using Microsoft office 2007 version. Can you guide me how to do the same job in this version?
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