B
Bill Padgett
I have an excel worksheet that has a column named "Name" and another named
"SSN". All "Name" will have an "SSN" attached to it. The "SSN" however is
only the last 4 of a SSN so neither column can be considered a key, but the
two together seem to work as a key(date of birth is also in both files). I
have the "Name" and full "SSN" fields located on a shared drive in an Access
database (I don't remember its name) in tblalpharoster which also has an
"email" field. The "Name" in the Excel spreadsheet and the "Name" in the
Access database actually come from the same Personnel database so will match
exactly, but in the Access database full SSN is used as the key to avoid
duplicates.
I am hoping that their is a macro that can be run in the Excel spreadsheet
that will add a column called "email" after the "SSN" column. The macro will
then look for a match between "Name" + "SSN" in excel and "Name" + last 4 of
"SSN" in access and bring the e-mail into excel if it is a match.
Thankyou,
Bill Padgett
"SSN". All "Name" will have an "SSN" attached to it. The "SSN" however is
only the last 4 of a SSN so neither column can be considered a key, but the
two together seem to work as a key(date of birth is also in both files). I
have the "Name" and full "SSN" fields located on a shared drive in an Access
database (I don't remember its name) in tblalpharoster which also has an
"email" field. The "Name" in the Excel spreadsheet and the "Name" in the
Access database actually come from the same Personnel database so will match
exactly, but in the Access database full SSN is used as the key to avoid
duplicates.
I am hoping that their is a macro that can be run in the Excel spreadsheet
that will add a column called "email" after the "SSN" column. The macro will
then look for a match between "Name" + "SSN" in excel and "Name" + last 4 of
"SSN" in access and bring the e-mail into excel if it is a match.
Thankyou,
Bill Padgett