Click here to Skip to main content
11,578,241 members (62,713 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: 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 0: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 at 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 at 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
0 Richard MacCutchan 165
1 OriginalGriff 150
2 Peter Leow 150
3 Afzaal Ahmad Zeeshan 100
4 Frankie-C 75
0 OriginalGriff 880
1 Sergey Alexandrovich Kryukov 685
2 Abhinav S 573
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 393

Advertise | Privacy | Mobile
Web04 | 2.8.150603.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