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

Answer 1

We are opening the saved workbook which is an existing workbook.

The user will be going to save the excelworkbook and open the same workbook

so, when the saved workbook is reopened at that time we are using this workbook open event to perform respected operations

Answer 2

https://stackoverflow.com/questions/24692802/excel-vsto-workbook-open-event-not-firing