Page 3 of 3 FirstFirst 123
Results 41 to 44 of 44
  1. #41
    shell is offline Member
    Join Date
    May 2014
    Posts
    3
    Rep Power
    0

    Default Re: Store data from Excel to Database without duplicate values

    Project_ID Project_Name Type Manager_Name Start_Date End_Date Phase Phase_Start_Date Phase_End_Date Overall_Sizing Actual_Burnt Overall_Status
    1 ASD SQP Sathish K Collam 9/20/2013 8/31/2014 Project Initiation 9/20/2013 1/30/2014 35000 25000 Green
    2 DFR SQP Sathish K Collam 9/20/2013 8/31/2014 Plan & Analyze 1/31/2014 2/27/2014 35000 25000 Green
    3 GHJ SQP Sathish K Collam 9/20/2013 8/31/2014 Architecture & Design 2/27/2014 3/14/2014 35000 25000 Green
    4 ERT SQP Sathish K Collam 9/20/2013 8/31/2014 Build 3/14/2014 4/4/2014 35000 25000 Green
    2 ABC TS Kunal 9/21/2013 8/24/2014 Plan & Analyze 5/30/2014 8/30/2014 30000 20000 Red



    This is the table m working on where Project_ID and phase are primary keys

    here rows 2 and 5 have duplicate primary keys. Can you please suggest on how to handle them. I need to provide the user with an UI with the duplicated rows where he selects which one to add or remove in the database..

  2. #42
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Store data from Excel to Database without duplicate values

    Seems to me you have your requirements specced out already, so I'm not sure what the problem is.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #43
    shell is offline Member
    Join Date
    May 2014
    Posts
    3
    Rep Power
    0

    Default Re: Store data from Excel to Database without duplicate values

    Dfgdfg

  4. #44
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Store data from Excel to Database without duplicate values

    Pardon?
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Page 3 of 3 FirstFirst 123

Similar Threads

  1. Replies: 9
    Last Post: 04-18-2013, 01:16 PM
  2. Replies: 1
    Last Post: 01-24-2013, 10:30 AM
  3. How can i store a data from Excel sheet to an array.
    By deshmukh.niraj04 in forum New To Java
    Replies: 0
    Last Post: 05-03-2011, 07:33 AM
  4. How to read data from excel and store it in db
    By saran123 in forum New To Java
    Replies: 5
    Last Post: 10-03-2008, 11:19 AM
  5. How to store extracted xml values in a database?
    By palanikumark in forum Advanced Java
    Replies: 6
    Last Post: 05-30-2008, 01:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •