Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to get access to NAV database in MS Excel

Posted on by

Hi All,

I wanted to know how can I get access to the NAV database in MS Excel so that I can use it for XML Mapping?

Thanks in advance.

*This post is locked for comments

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    RE: How to get access to NAV database in MS Excel

    Hi,

    You can create a Page with source table as the table that you want data from.

    Add Fields to the page that you need. If require add filters in the page properties.

    Once all done. Create a Webservice for the page created.

    Once the web service is created and published, you can use the SOAP URL for getting the data in XML Format.

    How to publish a web service. 

    ** Remember use SOAP URL not the ODATA URL for getting data in XML Format. 

    Let us know if any issues.

  • RE: How to get access to NAV database in MS Excel

    Hi Saurav,

    I want to save the file as a xml data file and not a excel workbook. Can you suggest a solution for the following.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    RE: How to get access to NAV database in MS Excel

    Hi,

    As you are using NAV 2017.

    You can actually create a page / Query which you can Save as Excel. if there is no style sheet defined in the database you will get the XML Mapping for the data.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: How to get access to NAV database in MS Excel

    To start, open Microsoft Excel and select the Data tab.

    From the Get External Data section of the menu, navigate to From Other Sources. | ...

    In the data connection wizard, enter the name of the SQL Server and your login credentials:

    Click on Next.

    In the next window, select the database and table ...

  • RE: How to get access to NAV database in MS Excel

    Hi Sowkarthika,

    I have already tried what you have suggested.

    But how can I get access to the schema of the NAV database which i can use as XML Mapping so that i can create a .xml document from Excel.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to get access to NAV database in MS Excel

    Can you provide more details on your requirement ?

    Guess this is what you are looking for : You can create an XML port and add tables & fields required. Then you can run the XML port and export it. You will get the format of XML Mapping.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans