Subscribe via RSS Feed Connect on LinkedIn

Excel

Dynamics NAV Excel Import

9th March 2015 0 Comments
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 […]

Continue Reading »

Dynamics NAV 2013R2 Excel Buffer Part 1

18th October 2014 0 Comments
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 […]

Continue Reading »

Dynamics NAV 2013R2 Excel Buffer Part 2

18th October 2014 0 Comments
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 […]

Continue Reading »

Dynamics NAV 2013R2 Excel Buffer Part 3

18th October 2014 0 Comments
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 […]

Continue Reading »