data import from excel into AX Table

(0) Share

Report

Posted on by Mukesh Bisht

Respected team

Im trying to import data from excel sheet into a newly created table in AX via creating a job , able to insert only 723 rows to be exact out of 2600 or odd rows . Could anyone help me with this as to why this is happening , any help would be greatly appreciated. Thanks .Attaching the screenshot of the code.

All responses (4)

Answers (1)

Mukesh Bisht 90 on at

Like (0)

Report

RE: data import from excel into AX Table

Thanks Ergun , I rechecked it it was indeed the issue with spaces in excel , certain columns were empty , did some data cleaning and now it's alright . Thanks again
Verified answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: data import from excel into AX Table

If it stays on the same record every time, there is a problem with that line. If the code ends without errors, that line is empty(variantType=empty), you can try change record (not just value but format too)

But if it gives an error, you need to check for formatting etc. You can try to catch the error with try / cacth.

Or you can try to read the relevant line one by one (try taking 5-10 records in that range into a different excel)
Mukesh Bisht 90 on at

Like (0)

Report

RE: data import from excel into AX Table

No there's no space as such , I checked it .
Suggested answer

ergun sahin 8,816 Moderator on at

Like (0)

Report

RE: data import from excel into AX Table

Can you look at the 724th(or 723) record? Is column 1 empty?