Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
I'm not familiar with this technology, but this looks promising: mibuso.com/dlinfo.asp?FileID=350 –  Justin Scott May 8 '09 at 3:24

2 Answers 2

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.

share|improve this answer

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

share|improve this answer
    
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.