Data Loader from Excel to NAV R2

(0) Share

Report

Posted on by myoung44708

128

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

All responses (1)

Answers (1)

Verified answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Data Loader from Excel to NAV R2

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

www.mibuso.com/dlinfo.asp