This question already has an answer here:
- Update Sharepoint list using excel 9 answers
I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server.
We need to append the data from the new excel sheets to the existing lists items of the SharePoint list.
How should I go about creating a solution for this?
Let's say I have 100 records in one excel file. I have imported that file to spredsheet app. It works fine for first time. Now I have 100 records in that list. Now user has added 10 more records in that excel sheet. That 10 records I have to appends to the list which is created very first time.