hello,
I am trying to merge two different database files that are currently in Excel documents.

database #1 has about 62,000 items in it. It has two different columns. one column has the part numbers. and the second column has the prices.

database #2 has about 20,000 items in it. It has two different columns. one column has the part numbers, and the second column has the full item description. This description in about two paragraphs long.

I am triing to work with Database #2. I need to have a database that has the part number, the price , and the item description.

Alot of the part numbers in database #2 are in database #1, But not all. Thats ok.

is there a way I can send the prices and part numbers in database #1 to their respective part number in database #2 ??

Most of the item part numbers in database 2 are in database 1. , but not all.

Example:

Database 1.

item part number-----l Item Price ------ l
abcd3344 ------------ l 200.00 ----------l

Database 2.
item part number-l item description

abcd3344 -------l This is the item specs


I would like the following result.

Database 3.

item part number--l item Price--- l item description

abcd3344 --------l 200.00 ------l this is the item specs....

The FIRST person to give instructions on how to do this successfully will receive a New Free 256MB USB memory thumb drive. To get the drive you have to give me detailed instructions from start to finish. These instructions have to give every step of completing the task needed. Every window to open, every step to take.The Free memory drive will be shipped immediately after the instructions given have been proven to work.
[email protected]

I appeciate your help.

BOB