The scenario:- I have to import .xls files into navision database. After importing the file has to be moved into another folder namely “Completed”.
Issue:- this has to be automated using Job Queue.
**Tried Solutions:-**Used Dataport and Report. using both these objects i am able to import manually but using Job Queue
the following errors were thrown
**DATAPORT:-**The object is not compatible with NAS.
**REPORT:-**This message is for C/AL programmers:
The call to member Open failed. Microsoft Office Excel returned the following message:
Microsoft Office Excel cannot access the file “Path\file.xls”
PLEASE HELP…!!!
You are correct that dataports will not work with the Job Queue, so you have to use a report or codeunit.
What login is the NAS running under? Does it have permission to access that folder? What have you already tried to solve the problem?
Googling “Microsoft Office Excel cannot access the file” shows plenty of things to try.
I have all permission to open and modify the file.
I can manually import data by running the report, but with job queue it does not work.
The problem rises only while accessing with job queue.
You should check the permissions of NAS user not yours…
Can you suggest some other method for importing excel files