Hi, I have multiple excel sheets on different systems and an existing sharepoint list on the sharepoint server. We need to append the data from the excel sheets to the existing lists items of the sharepoint list. We need to do this regularly with newly incoming excel sheets. can you please provide some ideas on how to provide a solution for this?
(Visited 23 times, 1 visits today)
Then also using timer job you can achieve this
Or – Create a custom web part with one button on it and add to your site ..
On button click write code to append Data .. whenever new excel is added click on button
(Visited 1 times, 1 visits today)
