I am trying to connect to our company SharePoint site to retrieve and edit the records. I would like to be able to pull the information into excel and then make changes on it and send it back to SharePoint.
I need to make a connection to the SharePoint and query the data so that I can pull specific records. Then I need to be able to send those updates back to the site.
I have found some information on connecting to the site but I do not know the table names to be able to query the data and make changes.
Any help would be greatly appreciated.