Hi Everyone,
I have the requirement so that users can upload excel sheet to the application and save into database table and if the records already exists in table then it will leave that duplicate record.
meaning, duplicate records from the sheet should not be uploaded to the database table. Please suggest me how to get this done.
Thank you,
Shubham
Discussion posts and replies are publicly visible
Hi Shubham, I had similar requirement long back. if you are dealing with large data then i would suggest you to create a stored proc to handle all db tasks like update , insert and delete.