Hi,
Is there any way to upload / connect the excel data with a sharepoint 2013 List. I have tried few addon which changes the excel data in table and uploads to a sharepoint list however the issues is i am not able to update the same data again . this allows me to update data to new sharepoint list but not amend on the existing one. Also got one addon which does the same job but limitations is ,we have to define the table range to 50000 ,this one works but SP will have blank rows, (ex if excel has 30 rows data and 49970 rows will be blank SP will have the 49970 blank rows) which doesn’t looks good. Is there any way to amend the SP list with excel file. (if we do changes in Excel this should be updated in SP also)
Many Thanks
Appreciate your help.
Regards
Satish
Hi Satish,
As you have discovered, SharePoint no longer syncs with Excel. However, SharePoint does sync with Access. Read this article on how to link a SharePoint list to Access, which I hope will meet your needs.
