Can Access find and combine duplicate fields when one of the fileds co

[Cowboysooner]

I have two tables. One with Company Name, Number of Employees and Address, the other with Company Name, Sales Size, Address and Phone Number. The tables are from different sources.

Can I combine the records of these files based on a 70%-90% match of characters in the company name field? The company names are not always spelled alike.
For example:
The Villages, Inc.
The Villages
Villages, Inc.
Villages Inc

 

[fullkeel]

In a word NO. Problem is you need something unique in each that would separate them from the others in each of the tables but unique to each other across the two tables.

The only way around this without some super elaborate filtering system would be to add a unique key field in each table and assign the same key in one table for say 'Villages, Inc' and the same key in the other for 'The Villages'.
An over simplification of this but probably the proper way would be to create a company ID for each company and then it wouldn't matter how the company was spelled as you would be retrievng data by the ID and not the name.