For example, already added a long list of contact people (name, phone, email, address...) in an excel file, how can I just upload the excel file to transfer the data to a table on the SQL server by ASP.Net code?I need to check below condition in my code.I have solution between 4 to 6.
1)Duplicate checking for existing value
2)Checking Excel Column name
3)If email already exists then popup confirmation message either for ("Delete & Add" or "Add" only)
4)Required field validation
Any help will be most appreciated!