
Good morning all.
Is there a data loader program for taking large tables of information from an Excel spreadsheet and placing it into the form sets within NAV? I want to control the load and not dump it directly into the tables, creating transactions that are auditable. I have used a program called DataLoader in Oracle 11i in the past and it worked great. Is there a third party program for NAV?
Martin
*This post is locked for comments
I have the same question (0)hi,
some solutions:
- use NAV 2013 rapid start services to import data from Excel (you can import on temporary tables instead of productin and after you can check imported data)
- use XML Ports using .csv, .txt or.xml instead of Excel format (save as format)
- use Sql integration services using data import workflow and build a log file during import
ore use Excel Import Export Wizard - NAV 2013