We can retrieve the data from the Excel file using two ways:
1. OLeDb Connection
2. Interop Library
Here we are going to use Interop Library.
We have a list of contacts in an Excel file named (Contacts.xlsx) with their Record ID, the scenario here is to retrieve the ID from Excel then use the ID to fetch the record from CRM and update the Contacts field “AE Assigned” to yes.