What are the suggestions for on a daily basis loading the latest Excel file from a shared drive (it is not on the SharePoint server) to a document library. The example would be retrieving a file called contacts.xlsx located on a shared drive into the Doc Library on SharePoint called Contacts.
I've done this before using a PowerShell script that was scheduled to run daily by Windows Task Scheduler.
Unfortunately Power Shell is not available for us to run Thus, I was hoping it might be accomplished within Nintex..
I am facing similar task, where a CVS file gets downloaded from SAP with a lot of information which then is needed to be updated into the Sharepoint List with relevat data only e.g. Holiday Balance etc.
I been thinking about how to tackle the task :/