Showing posts with label AL code. Show all posts
Showing posts with label AL code. Show all posts

Friday, March 5, 2021

Sunday, September 29, 2019

Import Excel file to Dynamics 365 BC using AL code

Hi All,

I find new information on how to import an Excel file into Dynamics 365 Business Central using AL code. Hence I thought of writing a blog.


Below is the code which shows importing an Excel file in D365 BC Azure/Online model.

Step 1: Create a Code unit
Step 2:Write all the logic required to Import, Read the Excel file, and Insert the data into a target table, In my case it is the Job Journal table.
Step 3: Call this Code unit from a Page Action.