How can i Import of data from EXCEL to NAV 2013 ?

Another option is to use our new improved Excel Buffer feature where you read the all the information from the Excel sheet into the Excel Buffer table 370

We are planning to do a couple of blog posts (http://blogs.msdn.com/b/nav/) on the Excel Buffer within the next couple of weeks, but here is an example on how to read.

This example will illustrate the reading capabilities that are possible.

1. Create a new codeunit
2. Add a new temporary record variable for table 370 called ExcelBuffer.
3. Add a new text variable called MessageValue
4. Then add the following lines:

ExcelBuffer.DELETEALL;

ExcelBuffer.OpenBook('C:\TEMP\ExcelBufferReadBookScenario.xlsx','Sheet ABC');
ExcelBuffer.ReadSheet();


IF ExcelBuffer.FINDFIRST THEN
REPEAT
MessageValue := MessageValue + ExcelBuffer."Cell Value as Text" + '\';
UNTIL ExcelBuffer.NEXT = 0;

MESSAGE(MessageValue);

Yes the performance has really changed dramatically to the better, since we are now executing and generating everything on the server instead of the “chatty” client / server automation solution. We don’t have any specific numbers, since this is based a lot on the size of the Excel worksheet you read or write. But try it out and I’m sure you will not regret it.