Need to compare 2 created database match and add to less .

  • Thread starter Thread starter atb
  • Start date Start date
A

atb

Problem;

1) I was sent 2 excel spread sheets with various field add on one and not on
the other, I used access to create 2 databases so I could match the records
with a common field (item number), grab the items missing off one and add
them to one of the sheets, so I could get a complete list.

any ideas what's the best way to do this, I've tried to do it in excel but
no such luck. don't think it allows me to extract data from one sheet and add
it to another.

sort of confured, I search everywhere for some type of fomula that would
allow me to compare the 2 databases, find the 1 common item (item number) and
add or append the missing fields to either 1 database or create a 3rd
database that will combine both items...
 
Hi,
If you don't have any experience with Access databases and don't understand
how to normalise data, you would be better off doing the process in Excel.
It will be much quicker to do it in a program you are familiar with.
Create a new worksheet in excel combining both spreadsheets.
Create an auto filter
Filter on the common field - item number
Manually add the missing item number to rows where needed.
The above will be a lot quicker than trying to learn how to do it in Access.

Jeanette Cunningham
 
IF the item number is unique (never more than one occurance in one of
the tables)

A) in design view for one of the tables make the item number indexed -
NO Duplicates. (or make it the key field)

B) Create an append query using the query wizard -
1) have the other table ( the one you did NOT change) as the
table (Show tables and select this second table)
2) Change the query type to Append and select the first table as
the one you want to append to.
3) Select ALL of the fields from the table (do not include the
ID field if one was created when you created/imported the table) and
drop all of those fields onto the grid.

C) Run the query.

Your original table will now have one entry for each of the unique
item numbers.

Ron
 
Back
Top