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.