web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / RapidStart Import from...
Microsoft Dynamics NAV (Archived)

RapidStart Import from Excel limitation

(0) ShareShare
ReportReport
Posted on by BorisK 132

I am importing from Excel in a RapidStart profile, the source Excel sheet contains 9 columns and 75K rows, but the import simply stops after importing 9554 records. No errors, just stops.
Max upload size on the NAV server, if it matters, set to 30Mb. The file is only 3Mb.
Is there any other setup somewhere that does it?

*This post is locked for comments

  • Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    Check in excel file is there any speacial or junk characters after the row 9554

    Or

    Try to import the records in multiple parts

  • BorisK Profile Picture
    BorisK 132 on at

    The file looks absolutely fine around row 9554, I tried to cut into two and import each of the halves, and still only imports 9554 records. Stumped.

  • Hasitha Jayasuriya Profile Picture
    Hasitha Jayasuriya 645 on at

    Hi Borisk,

    What is the table you are trying to import ?

    Regards,

    Hasitha J

  • Verified answer
    BorisK Profile Picture
    BorisK 132 on at

    Hi Hasitha

    It's a bespoke table - and Microsoft support gave me the answer.

    Apparently it has to do with the old Excel limitation of 65536 rows per sheet.

    The XML engine doing the import and export in NAV2013 is somehow still affected by it, so only up to 65536 records can be imported or exported.

    Oddly if the number of records in the file exceeds 65536 NAV only processes the difference between the number of records and 65536. So if the file contain 65537 records it will only import 1 and then just stop!

    In my example the file contained 75090 records, so 75090 - 65536 = 9554 were imported.

    Weird.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans