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)
NirvanalearnerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.
NirvanalearnerAuthor Commented:
if i am admin how can do it through dataport please guide
Ganesh Kumar ASr Infrastructure SpecialistCommented:
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

NirvanalearnerAuthor Commented:
Thank you very much. will this also work for Navision 2009
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

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
NirvanalearnerAuthor 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
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.
NirvanalearnerAuthor Commented:
but is there no way i can use any third party tool to read ui elment and automate?
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.
NirvanalearnerAuthor Commented:
OK, will see if I can use any tools like automation anywhere
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.