Import Excel in Business Central
Many times we need to import data through excel file in the business central / navision. We used to perform this kind of activity in the navision but we need to explore the thing in business central. So, i am trying to import data from excel file in the business central. I am using business central wave 1 2020 for the development.- We will create a table called student and add some fields to test imported data from Excel in Business Central.
- Now, We will add a new list page to view imported data from excel.
- Now, We will create a new report to import data from the excel in business central. If you worked with the navision then you might be noticed that some of the functions are not working in the business central due to scope issue. So, we will replace those functions which we used in NAV and try some new available functions to import excel.
- Now, we will add an action to the list page for import data.
Output
- Go to the student list page and click on the action Import Student Data.
- Select Excel File to import data in business central.
- Now, you can see the data is imported in the table.
You can download source code from GitHub (ClickHere).
Hope this article might be helpful for you in import excel.
Export Data in Excel in Business Central (ClickHere).
Comments
Post a Comment