Microsoft Dynamics NAV (Archived)

Import Excel into NAV 2016

(1) Share

Report

Posted on by Community Member

Hello,

I would like to import an excel spread sheet with 200 part number and quantity

Can't fin anywhere a import button or import...

Thank you,

Alex

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

to which table do you want to import?

did you check rapidstart services?

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Hi DonAlonzo ,

Importing can be done via "Configuration Packages"

System path :

Departments/Administration/Application Setup/RapidStart Services/Configuration Packages

But to do this you must have well understanding and knowledge, if ou dont know to do this its better to contact your vendor

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

You can use rapidstart services to import data

Or

You can use XMLPORT to import data

Or

You can simply open table and paste the data

By looking at your requirement it is like you need to import item parts in item table and then import the quantity in item journal and post it

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Alex,

You can make use of Rapidstart Services or XMLPorts as well.

Refer below link:

https://www.youtube.com/watch?v=XxK0SxE95_k

https://msdn.microsoft.com/en-us/library/dd338846(v=nav.90).aspx

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thank you for your answer, but seem really complicated for what I'm doing... maybe I was not clear enough .. Here's another try :)

I have place an order with my supplier but with the excel sheet HE provide. I fill up the quantity I needed. and now I want to send this excel sheet in NAV and create a blanket purchase order.. hope this is clear enough

thank you very much !

Alex

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thank you for your answer, maybe I was not clear enough .. Here's another try :)

I have place an order with my supplier but with the excel sheet HE provide. I fill up the quantity I needed. and now I want to send this excel sheet in NAV and create a blanket purchase order.. hope this is clear enough

thank you very much !

Alex

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

For importing this you need to create header first and then by using rapidstsrt services you can import the lines by specifying blanket order no

Or

Need to create xmlport to import the details

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I guess i'm not enough qualify to doing this... I'll start typing.. :( thank you all,

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

ohh you dont need to do it just got your requirement

at least copy and paste Lines

arrange your excel as your line header appear

and paste rose to your order Line tab all

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If I copy paste lines;

I select all the line needed to be paste, and when I go to NAV to paste it, it paste only the first row and in the first cell...

Was this reply helpful? Yes No