import of excel sheet

Comments

• Options

  julkifli33 Member Posts: 1,073

  2010-10-13

  have you create that dataport?

  0
• Options

  sudhakarsv Member Posts: 100

  2010-10-13

  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.

  Regards,
  S.V.Sudhakar

  0
• Options

  Marije_Brummel Member, Moderators Design Patterns Posts: 4,262

  2010-10-13

  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

  Marije Brummel | Freelance Business Central Specialist

  0