I want to compare fields from two files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to reconcile fields from two different sources that have the same
field names. Both files have the following fields that I plan to import to
separate tables:
Social Security number
Last Name
First Name
Loan ID
Disbursement ID
Disbursement Sequence Number

How do I assign a key to these tables once I import them when the only thing
that distinguishes on record from another is a combination of the Loan ID,
disbursement ID and Sequence Number?
 
I think I know the answer to my own question. I need to designate all fields
that make the records unique as the primary key - and then do an unmatched
query.
 
Back
Top