How to connect a Navision database to Excel?

Business Central/NAV User Forum
1

Hi,

I want to connect navision database to excel and retrieve some data from the tables.

Is it possible and when i see the drivers in the administrative tools there is nothing like navision native server

I am using native database.

2

Install C/ODBC from the Navision Product CD.

3

Or if you’re running Navision on a SQL Server database, then just use the standard SQL ODBC driver and use Excel Query.