Click here to Skip to main content
11,932,402 members (53,024 online)
Rate this:
Please Sign up or sign in to vote.
See more: MS-Excel table
I am uploading an excel sheet into sql table.
I want to upload a data without duplicates.
If the data already exists in the table, that should update the table.
If the data doesn't exists in the table, then that should append the table.
Kindly say the solution for it.
I tried with many codes..All flopped...
Posted 5-Jul-12 1:33am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

IF EXISTS(SELECT * FROM table WHERE id1 = @id)
     -- do the update because you know it exists
     UPDATE Table SET field1 = @field1, etc.
    -- do an insert, because it does not exist
    INSERT INTO table ...
comeshyamala 6-Jul-12 3:26am
Thank you so much...But i want to know the code in
I dont know how to connect to sql by using
ryanb31 6-Jul-12 7:52am
There is a lot to it, more than I can give you here. Do you not have a SQL class already to connect to db? Look into the SQLDataSource and SQLCommand objects. You will use those.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.151126.1 | Last Updated 5 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100