Notifications
Announcements
No record found.
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.
Can you look at the 724th(or 723) record? Is column 1 empty?
No there's no space as such , I checked it .
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)
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 669 Super User 2025 Season 2
André Arnaud de Cal... 471 Super User 2025 Season 2
Martin Dráb 423 Most Valuable Professional
