Transfer spreadsheet

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10404-transfer-spreadsheet.html
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10404
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

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10404
> 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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10404
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