Matching fields from 2 databases

Hi, I am in the process of matching up fields from 1 database to fields in a 2nd database. Each database is unique in the sense that they name things differently, one has some fields for things that the other does not, etc. But, I am trying to think of the best way to get a good chunk of the matches done in bulk, then looking at everything individually. So, my question is: Is there a way to compare 2 different columns, and if a cell from column 1 contains the same words, or similar words as column 2 then match them together.

An example would be Database1 = Red Brick House Multi and DataBase2 = Red_House_2 Story - Probably not the best example, but hopefully you understand where I am going with it... I just need to find similar values within each comparison column and then have them matched up together.

I don't know if there is a way to do that or not, but, figured was worth asking the question. Or, if anyone has any suggestions regarding a different tactic, I would love to learn. Thanks for any help!

No, not easily. You could start with an inner join in the fields and see how far that gets you, but there's no way of doing a fuzzy match to the extent you want - it would take a huge amount of work unless there's more of a pattern between the data fields than you've indicated.

Ps to help with your searching, databases don't have rows and columns, they have records and fields

Well, the data dump from each database was into excel so that is how I am matching the two and why I referenced as columns. Question, what are the limitations of the fuzzy match?

Why have you posted this in an access sub forum if you are using excel?