Excel
Dynamics NAV Excel Import
In Dynamics NAV I can use the Excel Buffer functions to import an Excel Worksheet into the Excel Buffer table and then use the data to insert or update records in the database, looking at the existing Reports in the Cronus database to import from Excel, they use a Case Statement to insert or update […]
Dynamics NAV 2013R2 Excel Buffer Part 1
Table 370 Excel Buffer This post is the first in a series of three on using the Microsoft Dynamics NAV Excel Buffer, the Excel Buffer in Dynamics NAV is little used in the Standard Object range, if we search for an example to import cells from Excel into a table we only have a few […]
Dynamics NAV 2013R2 Excel Buffer Part 2
This Post is the second in a series of three on using the Microsoft Dynamics NAV Excel Buffer, if you have not read part one you can Read it Here, in this post I will look at creating a Report that I can use as a Template to enable me to import data from an […]
Dynamics NAV 2013R2 Excel Buffer Part 3
This post is the last in a series of three on using the Microsoft Dynamics NAV Excel Buffer, if you have not read part one you can Read it Here, if you have not read part two you can Read it Here, in this post I will use the Template Report I created in part […]