Buffer – Pardaan.com

Microsoft Dynamics 365 Business Central: How to use Excel Buffer to Import data With Multiple Sheets?

In order to explain import function from excel simply and clearly, For Demo, let’s assume we would like to Import data To Sales Header Table with associated Sales Line entries. Source : MADHDA Read more...

9 August 2021

Dynamics NAV & BC Tips & tricks

How to import Excel files using Excel Buffer

Last week, I saw a question about importing data from Excel file to Business Central using AL Language. A few years ago, the only solution was to use DotNet integration. However, with the Business Central, there is a much quicker and better approach. Source : Microsoft…

19 March 2021

Dynamics NAV & BC Tips & tricks

Handle any CSV file with the CSV Buffer

In this video, I show to use the CSV Buffer to import an “unusual” CSV File using the CSV Buffer functionality. Source : Hougaard.com Read more...

4 February 2021

Dynamics NAV & BC Tips & tricks

Import data with the Excel Buffer

In this video, I show an old favorite, the Excel Buffer. A great way to get data into Business Central. I create a few handy extra functions to make the experience nicer. Source : Hougaard.com Read more...

25 November 2020

Data & Analysis

Table.Buffer() Does Not Buffer Nested Values

It’s actually really difficult to come up with a simple demo query to prove this though (the Power Query engine is too clever about not evaluating things it doesn’t need for the final output of a query), but it’s fairly easy to understand the principle. Whenever…

25 April 2019

Dynamics NAV & BC Tips & tricks

Excel Buffer Patterns for Import or Update NAV Data from Excel Files

Today I want to present how to use Excel Buffer functionality in order to update/import data in NAV/D365 Business Central based on data from Excel files. Bron : Andrei Lungu Lees meer...

21 September 2018