Data from Navision Financials to Access via Automation

Hi Has anybody tried to transfer data from Navision Financials to Access via Automation. If you have tried, will it then be possible that you could answer with an example. TIA PLI

Hi! It is possible to transfer data to and from Microsoft Access (or any other database supporting ODBC). I have done it using Microsoft ADO, ActiveX Data Objects. See http://www.microsoft.com/data/ for further information.

We have developed a database migration tool used mainly for converting a new clients old system to ERP. It uses Access as a medium between whatever old system they used and their exported data files, and then you create a data filled Access database using Navision fieldnames that you’ve matched to the old fieldnames within the Access GUI. This then creates data into the Navision database. It can also pull data from the Navision database if necessary. So… it can be done :slight_smile: Craig Bradney Technical Manager Criterion Technology Pty Ltd P:+61-2-9436-0436 F:+61-2-9436-1004 E:craigb@c-t.com.au