How we can validate excel data before import in SQL by using

Question

How we can validate excel data before import in SQL by using 

 

I need a solution that my client give the master data in excel sheet old + new data) it is difficult to find which one is new data, and even some data is updated with same Receipt No,which is already in SQL but not updated.

now give me solution how i can validate data when file upload control picks that excel sheet for uploading.


I want to try when an new excel sheet comes by client, client upload it to SQL by using file upload control but it should be validate first.if new entry come then it should be insert and if old record already in SQL then skip and if updated row comes then update in SQL server