Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Transfer spreadsheet

Discussion in 'Information Technology' started by JOM, Jul 28, 2006.

  1. JOM

    JOM
    Expand Collapse
    Guest

    I have a spreadsheet that I would like to import into my database using a
    macro. The thing is that there could be names that in the spreadsheet that
    if I transfer to my table it would create duplicate names. How will i avoid
    that. Sometimes there could be employee names that have the same first and
    last name but different birthdays and this is considered 2 different people.
    e.g., John Smith (b-Day) 01/01/80 and John Smith (b-Day) 12/25/65 are 2
    different people.


    Information in my table's column is as follows:
    EFirstName, ElastNanme, EBirthday EActive
     
  2. Loading...

    Similar Threads Forum Date
    Soul transfer to another body Questions and Answers May 10, 2014
    Sikh Guruship transfer Sikh Sikhi Sikhism Mar 13, 2010
    Transfer of Sikh "Guruship" Sikh Youth Mar 13, 2010
    Sikh News SC issues notices to Punjab govt on Tytler's plea for case transfer (New Kerala) Breaking News Sep 9, 2008
    Sikh News Nine IAS officers transferred in Punjab (Outlook India) Breaking News Aug 29, 2008

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    JOM wrote:
    > I have a spreadsheet that I would like to import into my database
    > using a macro. The thing is that there could be names that in the
    > spreadsheet that if I transfer to my table it would create duplicate
    > names. How will i avoid that. Sometimes there could be employee
    > names that have the same first and last name but different birthdays
    > and this is considered 2 different people. e.g., John Smith (b-Day)
    > 01/01/80 and John Smith (b-Day) 12/25/65 are 2 different people.
    >
    >
    > Information in my table's column is as follows:
    > EFirstName, ElastNanme, EBirthday EActive


    I hope you plan on having more fields than that. :)

    Select all three of those fields and then make them all part of the
    primary key. That will eliminate duplicates.


    --
    Joseph Meehan

    Dia duit
     

Share This Page