How to read the data from excel spreadsheet to NAV...I Created data in excel already and with same header nav table also created... how to populate the data from excel to nav table using code or anyother else ..........

please reply me

One option is to use Configuration Package.

Other Option :…/nav-2013-r2-import-excel-file-using-excel-buffer

Hi Praveetha,

Write Configuration package in search bar.
Create a new configuration file.
and define the table which you want to import with excel.
Export the excel file and then import the data into excel file.

Then import it in NAV.

For more info Follow,…/hh997463(v=nav.90).aspx…/how-to-set-up-configuration-package-in.html

I hope this will help.