Transfer spreadsheet

[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

 

[Joseph Meehan]

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.