Forum Discussion
mkmeach89
Jun 08, 2019Copper Contributor
Linking Data From Excel to Access to Sharepoint List
Hi - I retrieve data in Excel. I am trying to create a link from this data to a Sharepoint List so that the data can be shared in a separate template that includes that data as a Power Query. If ...
Woldman
Jul 22, 2019Iron Contributor
I'm not sure if I understand your situation right, but linking from Access to Excel and SharePoint doesn't automatically link the Excel-sheet to the SharePoint list. You need a query in Access to update the SharePoint list from Excel. The type of query depends on whether you want to update or reload the SharePoint list from Excel.