Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page