There are a lot of beautiful and useful Excel Import and Export tools for Navision from 2.7 to 2009 R2 such as Universal Excel Importer v1.2, SMART Excel Import Export, Universal Excel/Notepad Importer & Exporter.
However, there are limited Navision 20013 tools that support only for non-Unicode characters Text or XML files. Although Navision 2013 today supports paste data rows from Excel directly, it is suitable for small tables with some columns only.
Actually, Navision 2013 has powerful build-in Data Migration tool to exchange Unicode data with Excel. To make it simple as predecessors with 4 or 5 steps to import data from Excel sheet to Navision table, we have developed a wizard on top of standard Data Migration tool and called it “Excel Import Export Wizard”.
Through “Excel Import Export Wizard”, you can:
- Export tables data to Excel:
1.1 Select tables to be exported.
1.2 Choose needed fields to be exported.
1.3 Filter needed records to be exported.
- Import Excel Sheet data to table repeatedly:
2.1 Select Excel Sheet to be imported.
2.2 Excel Sheet Template checking.
2.3 Validate needed fields separately.
2.4 Review data before apply to table data.
You can find tools at our Skydrive link https://skydrive.live.com/?cid=1322d544fed91559&id=1322D544FED91559!107
It would be very grateful for your feedback. Hope you enjoy!
Thanks and best regards,