Forum Discussion
Updating SharePoint List from Excel
John White, jcgonzalezmartin is there a way to update a sharepoint list from Excel? (other than through 3rd party tools like SoftFluent's Sharepoint list synchronizer? http://www.softfluent.com/prod...
Hi Laura,
Updat
inge SharePoint from Excel is possible but more complicated. You have to use VBA and ado.net.
Here is an article I used a few years ago to do that : http://depressedpress.com/2014/04/05/accessing-sharepoint-lists-with-visual-basic-for-applications/
Updat
inge SharePoint from Excel is possible but more complicated. You have to use VBA and ado.net.
Here is an article I used a few years ago to do that : http://depressedpress.com/2014/04/05/accessing-sharepoint-lists-with-visual-basic-for-applications/
This article too seems to do the opposite. It allows for SharePoint list data to come into an Excel spreadsheet. We want our Excel spreadsheet to update our SharePoint list 😞