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

hello Franco, 

I am not sure what makes it so difficult to insert duplicate entries. Make sure the 'name' column is not set to 'unique' or 'primary'.

If problem persists, would like to have a look on the code.

Answer 2

is there other way to make a little easier to understand?

thanks again

Answer 3

http://stackoverflow.com/questions/11971264/multiple-mysql-records-with-same-name-different-id