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)
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 ..!
(Visited 1 times, 1 visits today)
