Excelbuffer to import xls in Nav 2013 R2

tullio
tullio Member Posts: 39
edited 2014-08-08 in NAV Three Tier
Cannot use Excelbuffer table to import xls file in Nav 2013R2?
I'm tryng but get error format file..

Only OPEN XML file format?=

Comments

  • beran
    beran Member, Microsoft Employee Posts: 80
    The xls is the old format for Excel documetns. The later versions Excel 2010 and 2013 use the xlsx format, which is basically a compressed OpenXml based document. If you really want to see it then download Open XML SDK 2.5 application - http://www.microsoft.com/en-us/download ... x?id=30425 and open the document.

    In this case you have to use Excel 2010/2013. Import the old xls file and save it as an xlsx-file. I am not saying you can import the file in Nav 2013 R2 but it is a good start.
    Eric Beran
    Software Design Engineer II
    Dynamics NAV Office 365
    Microsoft

    This posting is provided "AS IS" with no warranties, and confers no rights.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    We had the same issue on one of the projects and used ADO to import the sheet. This is extremely fast.

    Vjeko helped me with the code.

    http://vjeko.com/blog/excel-interoperab ... n-nav-2013
    Marije Brummel | Freelance Business Central Specialist

Categories