import of excel sheet

shweta

Hi
I want to import data from excel sheet through dataport. How I can do it.
Please its urgent.
Thanks in advance

shweta

julkifli33

have you create that dataport?

sudhakarsv

impoting the data through the excel sheet into the Navision is difficult.
So save the excel file as a .csv and then import into NAV through the dataport.

Marije_Brummel

The easiest way to import from excel is using the excel buffer table.

This has a function that moves the data from the excel sheet into table 370 where you can then process the tabledata.

http://www.mibuso.com/dlinfo.asp?FileID=596