How to Match Company Names

N

niladri20052006

Board Regular
Joined
Dec 3, 2010
Messages
121
Hi all,

I have unique contact list in Access consisting of 6,00,000 data where I have info but not the contact details. In another table I have the contact names. Only one thing that is matching between these two tables is Company Name. But the problem is in 6,00,000 table I have the full company Name (Like Zinfi Technologies,Inc) and in contact names table I have the company names but not in full (Like Zinfi Techno...). In that how will I match the companies?

Is it possible to do it in excel part by part?

Thanks in advance!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Upvote 0
But I am confused. Is there any better way or query?
Click to expand...
Not really, not without fixing/standardizing the data!

The whole concept of "relational" database programs like Access is to have common fields in your various table that you can link on. If you do not have that, you really do not have the makings of a good relational database.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Modifying templates and linking to new tables
2
Replies
13
Views
1K
gshock
G
G
  • Solved
Primary Key versus Foreign Key
2
Replies
14
Views
1K
jackd
J
J
  • Solved
Having a problem in the expression builder, very new to Access. It thinks I'm trying to use Automation objects?
2
Replies
15
Views
948
Micron
M
J
  • Solved
Unique ID field based on other fields entered in a record
Replies
7
Views
603
JAccess1706
J
JenniferMurphy
  • Question Question
How to structure a variable product rating database
Replies
5
Views
933
mdmilner
M

Forum statistics

Threads
1,224,522
Messages
6,179,299
Members
452,904
Latest member
CodeMasterX

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top