Import Data From Excel Sheet to Database!

Question

Dear Team,

 

As Its My First Question please Help.

 

My Question Is:

 

m able to insert data from excel to database using c# window form.But M not able to track each transaction on insert

query to get live update at run time . at the end it show numbers of data uploaded.

Is it Possible to get rejection of data from excel and validate error on each row of excel data.

 

 

Thanks In Advance(Team),