Hi All,
I'm having a real headache trying to import using excel templates. I have the one excel template file that consists of the following tables that need to be imported into AX 2009.
reqitem table
Invenitempurchsetup,
inveniteminventsetup
inventitemsalessetup
invenitemprice
inventable
inventablemodule
inventtxt
inventitemlocation
I have 11,919 records in each table, and selected all the lookup values and after a number of hours I receive the following error:
Error Microsoft Office Excel import\Importing Items from C:\Users\jramage\Desktop\DM1\Items\New Folder\Items (3)\Items.xls The number of arguments provided is different from the number of arguments accepted by the method.Error Microsoft Office Excel import Data import was interrupted
I'm tearing my hair out please help.
John
Hi John,
Are you getting this error from inside Ax? If yes -
This way you can clearly understand and identify the issue and fix it. Probably you would require a developer to assist you in this.
Good luck,
Harish Mohanbabu Long way to go before I sleep ..
Forgot to mention this -
On other note - I have come across cases of import running very slow in Ax 2009. I understand MS provide a fix for this issue. If you haven't got it already, do please contact local support.
Please note - the fix is only to speed up import process.