import data from Dynamics NAV

How do i import excel file (standard excel file) to Microsoft Dynamics NAV (2009 version), without admin rights (as a end user)
NirvanamanagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ganesh Kumar ASr Infrastructure SpecialistCommented:
You should need import rights especially admins can do through dataport.

Since you are end user, ask your developer to provide module to import the excel file to a custom table. The Developer should know what is your requirement so that he can build it properly.
0
NirvanamanagerAuthor Commented:
if i am admin how can do it through dataport please guide
0
Ganesh Kumar ASr Infrastructure SpecialistCommented:
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

NirvanamanagerAuthor Commented:
Thank you very much. will this also work for Navision 2009
0
Ganesh Kumar ASr Infrastructure SpecialistCommented:
yes it will work but slight changes would be there, use this article for Navision2009 - https://msdn.microsoft.com/en-us/library/dd339001.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NirvanamanagerAuthor Commented:
Hi Ganesh,

Admin says he cannot provide access to data tables as there is risk of corrupt file can be imported which will have an impact on the database. is there any way we can automate using a third party tool, which pics data in excel and paste it in to navision
0
Ganesh Kumar ASr Infrastructure SpecialistCommented:
I am not sure how your navision is designed is that having native database or integrated with SQL server 2008 / 2012. If it is native database then you cannot do the import without dataport / xmlport. But if you have SQL server as a backend for Navision then you can ask your admin to create separate table on the navision database and you can do the import and he can design the report and provide whatever you want. While using SQL server you can use SQL query statement to import the excel file / txt / csv file to table.
0
NirvanamanagerAuthor Commented:
but is there no way i can use any third party tool to read ui elment and automate?
0
Ganesh Kumar ASr Infrastructure SpecialistCommented:
Without permission on SQL server or native database you cannot do anything, the Navision has tight security model either in native or when used with SQL server. You need to have proper credential to do that so. Since the question you ask is looking for security flaw which is not there with Native Database and in SQL.

If you want to use MS Access then it is easy to import and export report.
0
NirvanamanagerAuthor Commented:
OK, will see if I can use any tools like automation anywhere
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.