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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Excel Requirements to ...
Small and medium business | Business Central, N...
Answered

Excel Requirements to import into Configuration Package

(0) ShareShare
ReportReport
Posted on by thegnic 75

We have a client that is looking to export information from their HR system and import the data into NAV (It is basically user info to be imported into Continia Tables in NAV). I know that I can specify the tables that I want and then export to Excel, copy the data they have exported from their HR system and paste that info into the exported Excel sheet and this will import ok. When they export from their HR system it comes out in csv format, with all the correct column names, 1st two rows set accordingly too, however when I save it as an xlsx filetype it won't let me import the data. I'm having to copy and paste from one sheet to another to get the data into NAV.

Is there a way around this? i.e. is there a way to configure the excel sheet so that NAV can import it without exporting the data from NAV 1st? I'm hoping to automate most of this process and was looking to avoid having to copy and paste from one sheet to another.

Any help or suggestions appreciated.

Here is the error:

2020_2D00_12_2D00_04-15_5F00_12_5F00_22_2D00_127.0.0.1_5F00_53317-_2D00_-Remote-Desktop-Connection.png

Cheers

Gary

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    I believe I have seen this before with some older releases of Office. What release of Office are you using and what CU of NAV 2018 is this?

    Thanks.

  • thegnic Profile Picture
    thegnic 75 on at

    Hi, NAV 2018 CU3 and Office 365.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    I would start by ensuring you are on a more recent build of Dynamics NAV 2018. We just released CU36:

    support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2018

    If you update one component, it is best to update the other components as well.

  • Suggested answer
    thegnic Profile Picture
    thegnic 75 on at

    Hi Marco, thanks for the reply. Just now getting a chance to look at this again. As this is a customers live environment I would need to arrange all of this with them.

    As it turns out, one of our developers is in the process of creating a codeunit that will carry out the import of the data we require.

    Thanks for your assistance.

    G

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at

    Good day,

    Excellent to hear, great to see you managed to work around it for now.

    Thanks.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans