I'm trying to find a way to upload data from multiple excel files (identical) into a sharepoint table.
One file is one project. I want to see the compilation of projects in my sharepoint list. And also ensure that my list is updated every time a file is updated.
I've been trying to create a code in my excel files to push data into sharepoint but I'm questioning if this is the best way. The code was originally created to push data into an access database.
Thank you for your help.