O'Reilly logo

Microsoft Dynamics NAV by Mark Brummel, Christopher Studebaker, David Studebaker, David Roys, Vjekoslav Babić, Cristina Nicolàs Lorente, Laura Nicolàs Lorente, Alex Chow

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Extracting data

Dynamics NAV offers several ways of analyzing and reporting data inside the application. If that is not enough, you can also extract data from the application and use external tools to report and analyze your data.

In this section, we will see the different ways you can extract your data from Dynamics NAV. Once it is outside the application, you can use the most convenient tool for you.

Data in Dynamics NAV can be extracted in multiple ways. The various ways include:

  • Copying and pasting to Excel
  • Extracting data through SQL Server
  • Any external data/reporting tools that can connect to SQL Server
  • Web services
  • EDI

The list goes on and on…

In this section, we'll focus only on two ways of exporting the data:

  • Sending data to Microsoft Office applications ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required