G
Guest
I am using Access to create a mailmerge. I receive a spreadsheet with
certain information on it. I have a table with Law Firm Names and address in
the database. The incoming spreadsheet is linked to the database and the Law
Firm Name is the joining field between the two tables. My problem is that
the incoming spreadsheet is always inconsistent in it's data entry of the law
firm names. So I always have to re-enter the names on the spreadsheet in
order for the link in the database to work. There is no other feature on the
incoming spreadsheet to link with the Law Firm names and addresses.
For example: In the Firm Address table the official name of the firm reads
like this: "James D. Angel L.L.P."
In the linked client data table the same firm is referenced as "James Angel".
Is there any way to work around all the extra data entry?
certain information on it. I have a table with Law Firm Names and address in
the database. The incoming spreadsheet is linked to the database and the Law
Firm Name is the joining field between the two tables. My problem is that
the incoming spreadsheet is always inconsistent in it's data entry of the law
firm names. So I always have to re-enter the names on the spreadsheet in
order for the link in the database to work. There is no other feature on the
incoming spreadsheet to link with the Law Firm names and addresses.
For example: In the Firm Address table the official name of the firm reads
like this: "James D. Angel L.L.P."
In the linked client data table the same firm is referenced as "James Angel".
Is there any way to work around all the extra data entry?