Hello,



I've tried searching for this but I'm not really sure what the technical terms are for it.
Also this may be more of a relationship question than an import question so if I should repost this in a different forum, let me know.

I have two spreadsheets with sales data that are related by one field (EmployeeName).
The problem is, the sheets were entered by hand and the names were entered differently in both sheets.

For example, Sheet 1 may have dozens of rows with the following EmployeeName fields:
Brown John
Wright Rick
Jones W Van

Sheet 2 has corresponding rows with the following names:
Brown
Wright, R.
Jones

Now I want to import both sheets into separate tables and then make a query that uses data from both tables.
However, the relationship won't work since the fields don't match up.
Is there any tool in Access that I can use to match up both sheets that will let me pick values in Sheet 2 and replace them with corresponding values in Sheet 1?
Or, if not, can someone point me in the right direction to solve this problem?

Thanks.