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?
Asked
Active
Viewed 1,109 times
0
-
I'm not familiar with this technology, but this looks promising: http://www.mibuso.com/dlinfo.asp?FileID=350 – Justin Scott May 08 '09 at 03:24
2 Answers
1
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.
Martin C.
- 670
- 1
- 6
- 12
0
Navision offers extensive exporting to tab delimited files from within the program.
Jack B Nimble
- 1,505
- 1
- 10
- 13
-
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 08 '09 at 04: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