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

Get Implementing Microsoft Dynamics NAV - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.