How to query Navision database

Question

I need to export some tables from Navision. It is configured to use the local datastore, not an SQL Server.

How can I connect to and dump these tables?

I'm not familiar with this technology, but this looks promising: mibuso.com/dlinfo.asp?FileID=350

Martin C. · Answer 1 · 2009-05-10 19:32:23Z

up vote 1 down vote accepted

If you have navision, you'll also have the NODBC driver on the install DVD, which should enable you to query it with a SQL syntax.

answered May 10 '09 at 19:32

feedback

Jack B Nimble · Answer 2 · 2009-05-08 04:15:18Z

up vote 0 down vote

Navision offers extensive exporting to tab delimited files from within the program.

answered May 8 '09 at 4:15

	The raw table dumps have been requested by auditors, unless navision can export to csv the raw tables, that isn't going to help. – Matthew Watson May 8 '09 at 4:37
	With a Dataport you can do exactly this. You can even export multiple tables with one dataport. – Martin C. May 10 '09 at 19:33

feedback

2 Answers