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

manikandan

Dear All,
How can i Import of data from EXCEL to NAV 2013.
Please help me? ](*,) ](*,)
Regards,
Muthusubramanian.M

mihail_kolev

you can import excel data from the SQL Management Studio (Right click on your database, Import Data, choose Microsoft Excel for data source) or write your own code in Navision, using the Excel automations or DotNet assemblies.

Belias

or you can copy/paste the lines in a list page

mohana_cse06

here is the full info on copy/paste
http://dynamicsuser.net/blogs/kine/archive/2012/06/05/microsoft-dynamics-nav-2013-tip-1.aspx

ddlarsc

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);

deV.ch

Is there a significant performance gain over the previous implementation via automation?
If so, are there any numbers?

ddlarsc

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.

manikandan

hi all,
Thanks a lot mihail_kolev,Belias,mohana_cse06 and ddlarsc for all your replies.
Now my problem is solved .

Regards,
muthusubramanian.M

navuser1

mihail_kolev wrote:

you can import excel data from the SQL Management Studio

NAV validation does not work in this case.

faizguy84

NAV 2013 has come up with Standard tool to import the data from excel. The tool is Config package Card which is similar to data migration tool of previous version, but much more faster and easier to use. this tool also has all the validations. So now when u upload a data it will be validated.

It is accessible through IT manager Profile. Under home --> there will be option Edit migration overview.

So more info, refer the below link
http://msdn.microsoft.com/en-us/library ... 6(v=nav.71).aspx