I'm on SharePoint 2010.
An excel file is uploaded to a document library.This excel file has a custom ID column(alphanumeric) and many more columns.
There is a list which contains many columns along with the same Id column.
This excel sheet gets updated for each ID on a weekly basis and hence the list data also has to be updated for the corresponding ID column
I am looking for options on how to import the data from the excel into the SP list matching the ID columns(ID columns in excel and list should match for updating the data).
What are the ways and how to achieve this?