Import data from excel to table

how to create xml port for importing data from excel to navision table in navision 2013 r2.

Please Guide.

Hi Seemab,

There are few different way you can do this. But it has been asked a 1000 times already.

But try this:

Thanks for your reply.
But i want exact step of how to create xml port for importing data.

You cannot import Excel files using XML ports. XML Ports are good for CSV and XML files.

Excel files are better imported using the Excel Buffer table/functionality. So if the data are in an Excel, then no reason to convert to text file first. Mark Brummel wrote a nice piece on it for NAV 2013:


If you still prefer XMLPorts, then try this:


Hello Seema, follow the below link: