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 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 😕