I have a DataSet, I have created an Excel spreadsheet using OData connection. Now I want to create a SharePoint List using this Excel data. I want the Excel and SharePoint List to be sync so that list has all the latest updates. Is there a way to achieve this.
You can do it by appending this to the end of the URL:
In Excel, choose External Data Connections > OData and enter the URL. Excel will prompt you to select the table you want.
Here is more information about what you can do with SharePoint Online and OData:
Hope this helps!
Yes, In order to synchronize Excel data with SharePoint, you need to convert a range of data into a table. The moment you create the table, Excel will show you an extra button to "Publish". Also if you want to synchronize Excel with SharePoint, you need to Install the Excel Addin. here i have provided the link for SharePoint 2007 addin. If you are working in any other version you can use that.
Hope this helps.