I have to update sharepoint 2013 list with data from excel sheets. Here, 2 excel sheets are being used. I need to update 2 columns of SharePoint list taking column A from one excel book and the other column from another excel book. My client doesn't allow visual studio coding. Is this possible? or atleast updating SharePoint list by taking only selective data (only 2 columns from entire data) from 1 excel book.
The ability to synchronize the data between a table and a list in Microsoft Windows SharePoint Services is deprecated.
for more info checkout msdn article MSDN link here!