Microsoft Dynamics NAV (Archived)

How to get access to NAV database in MS Excel

(0) Share

Report

Posted on by Lester DSouza

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

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Lester DSouza on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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 ...

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Lester DSouza on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No