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?
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
Thanks Mahesh for reply back but, I dont want to append it periodically. I just want to append to the same file. How can I proceed ?
Hi ,
You can create Timer job for this and schedule to execute once in Day .
Write code to read all excels one by one from all locations and then insert in SP List ..
All Set ..!
