Comparing 2 databases

Helen

Board Regular
Joined
Feb 19, 2002
Messages
103
I have 2 databases, both based on part numbers. I need to compare the two and find if the two databases have the same part & the same letters & the same values. They are also very mixed and some parts are different in both databases, therefore they cannot all match, but I need to match up what I can, so I can then compare the databases to see if they are the same.

I am not too sure if this makes any sense, but here is an example listing:

Database 1 Database 2
Part Let Val Part Let Val
72822 aa 22 72824 cc 44
72823 bb 60 72825 dd 45
72824 cc 44 72826 ee 100
72830 ii 98 72827 ff 64
72826 ee 100 72828 gg 59
72827 ff 64 72829 hh 72
72828 gg 59 72830 ii 98

- therefore I need a formula to search for the same enteries in both databases and return the values for example, or a variance
- for example 72830 ii 98 are the same in both databases.

I hope I have explained this clearly.
Thanks.
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Helen -
Some points of clarification:

By "database" are we talking about an Excel spreadsheet with this data on it? If I understand you, you have six columns of data.
On a given row, the two sets of three columns each identify a unique part. (ie, 72822 aa 22 is a unique part that you're trying to compare with the data somewhere in the next three columns.)

Is it possible that there is more than one match for a given data set?

Tom
This message was edited by Tom Morales on 2002-02-22 11:36
 
Upvote 0
Yes I do mean data in Excel, I shouldn't really call it a database I suppose.

Yes they are unique items in each database, and I'm not too sure if there might be more than one match, but not very likely so we'll go with not.

Is this possible to do somehow with a formula? I have no clue on VBA by the way.

Thanks
 
Upvote 0
On 2002-02-22 08:53, Helen wrote:
I have 2 databases, both based on part numbers. I need to compare the two and find if the two databases have the same part & the same letters & the same values. They are also very mixed and some parts are different in both databases, therefore they cannot all match, but I need to match up what I can, so I can then compare the databases to see if they are the same.

I am not too sure if this makes any sense, but here is an example listing:

Database 1 Database 2
Part Let Val Part Let Val
72822 aa 22 72824 cc 44
72823 bb 60 72825 dd 45
72824 cc 44 72826 ee 100
72830 ii 98 72827 ff 64
72826 ee 100 72828 gg 59
72827 ff 64 72829 hh 72
72828 gg 59 72830 ii 98

- therefore I need a formula to search for the same enteries in both databases and return the values for example, or a variance
- for example 72830 ii 98 are the same in both databases.

I hope I have explained this clearly.
Thanks.

Helen,

I guess you want to merge them into a single "database". If so, define a table PARTS in Access:

PARTS(PartNo,Let,Val),

with PartNo as primary key.

Choose Number as Data Type for Part No, Text for Let, and Integer for Val.

After you have defined the PARTS table,

Activate File|Get External Data|Import.

You should then be able select your .xls file, follow the steps of the procedure of Import. Pay attention to the fact that you import your 2 Excel "databases" into an existing table, that is, PARTS.

After the import, you'll have PARTS filled up non-duplicate records, which you can now export from Access to Excel.

Aladin
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

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