S
slakjaw
Greetings to all, this is my first post and (wouldn't you know it) I'v
got a problem!
I'm attempting to match two slightly dissimilar text fields.
I have 2 similar tables. Each contains records of companies, wit
fields such as COMPANY_NAME, PRIMARY_CONTACT, ADDRESS, PHONE...etc. On
table (Table B) has about 2,700 records and is much smaller than th
other table (Table A), which has 93,000 records. The smaller table WA
NOT created from the larger table and they do not share common uniqu
identifiers. Both tables are company listings, so their respectiv
fields contain similar kinds of data, though the field names of the tw
tables are not identical. The tables come from different source
entirely and just happen to both be listings of companies. The table
are not well designed to be properly relational relative to othe
tables within a normalized database. Most of the fields of both table
are irrelevant to my purpose, which is matching each the compan
records in Table B to that company’s record in Table A
Notes:
companies listed in table B are also companies that are listed in tabl
A. A major part of the problem seems to be that there are many ways t
spell company names, so there are few exact matches. There are eve
more ways to represent or misrepresent addresses, i.e. with or withou
suite numbers, numerals spelled out or not, Av./Av/Ave/Ave.
bl./bl/blvd./blvd, Saint or St. …the permutations go on and on…
My problem is as follows:
from table A in the new table C.
I would be grateful if someone could suggest an approach.
Thank
got a problem!
I'm attempting to match two slightly dissimilar text fields.
I have 2 similar tables. Each contains records of companies, wit
fields such as COMPANY_NAME, PRIMARY_CONTACT, ADDRESS, PHONE...etc. On
table (Table B) has about 2,700 records and is much smaller than th
other table (Table A), which has 93,000 records. The smaller table WA
NOT created from the larger table and they do not share common uniqu
identifiers. Both tables are company listings, so their respectiv
fields contain similar kinds of data, though the field names of the tw
tables are not identical. The tables come from different source
entirely and just happen to both be listings of companies. The table
are not well designed to be properly relational relative to othe
tables within a normalized database. Most of the fields of both table
are irrelevant to my purpose, which is matching each the compan
records in Table B to that company’s record in Table A
Notes:
company facility location is a record (not normalized)Table A contains numerous COMPANY_NAME field duplicates, because eac
does not have (field x and field y).Table A has two text fields (that I’m interested in) that Table
COMPANY_NAME field matches, but I know that nearly all of the 2,70I have determined that the tables have fewer than 500 exac
companies listed in table B are also companies that are listed in tabl
A. A major part of the problem seems to be that there are many ways t
spell company names, so there are few exact matches. There are eve
more ways to represent or misrepresent addresses, i.e. with or withou
suite numbers, numerals spelled out or not, Av./Av/Ave/Ave.
bl./bl/blvd./blvd, Saint or St. …the permutations go on and on…
I am using Access 2002, but also have Excel 2002 available
My problem is as follows:
table A company records and I need the x and y fields (containing dataI want to create a new table (Table C).
Table C would contain all table B company records that correspond t
from table A in the new table C.
I would be grateful if someone could suggest an approach.
Thank