Compare two database records

[Gary Crisp]

I am having trouble trying to match two excel records. These records are as
follows:
1) Invoiced items from vendor, including shipment number, part number,
invoice number, etc.
2) Items that are actually received, which have the same contents.

Is there a way to import both of these two excel files and use Access to
compare and report the differences?

 

[John W. Vinson]

I am having trouble trying to match two excel records. These records are as
follows:
1) Invoiced items from vendor, including shipment number, part number,
invoice number, etc.
2) Items that are actually received, which have the same contents.

Is there a way to import both of these two excel files and use Access to
compare and report the differences?

Yes.

Use File... Get External Data... Import to import the files into two tables.

Create a Query joining the two tables by whichever field make the records "the
same" - I don't know which those might be, invoice number and part number or
what.

Could you provide some sample data to indicate what you would consider
"different" - but still alike enough that you can tell that they aren't the
same but should be?

John W. Vinson [MVP]

 

[Gary Crisp]

Thanks for the quick response. I think that I confused you. What I am trying
to accomplish is a simple comparison from what the Vendor has invoiced to me
and what my shipping department says that we received. I want to import these
excel spreadsheets into Access to be able to easily match, let's say
"shipment numbers". I'm hoping by doing this, I can make sure that what I'm
being invoiced is really what I have received.

Vendor Invoice Record Our
Record
4229626
4229626
3580323
3580323
1452987
9875871
9875871

There will be between 75 to 225 of these per month to match, and I though
that it would be quicker to to do a comparison.

3524789

 

[Gary Crisp]

Thanks for the quick response. I think that I confused you. What I am trying
to accomplish is a simple comparison from what the Vendor has invoiced to me
and what my shipping department says that we received. I want to import these
excel spreadsheets into Access to be able to easily match, let's say
"shipment numbers". I'm hoping by doing this, I can make sure that what I'm
being invoiced is really what I have received.

Vendor Invoice Record
4229626
4229626
3580323
3524789

Our Record

3580323
1452987
9875871

 

[John W. Vinson]

Thanks for the quick response. I think that I confused you. What I am trying
to accomplish is a simple comparison from what the Vendor has invoiced to me
and what my shipping department says that we received. I want to import these
excel spreadsheets into Access to be able to easily match, let's say
"shipment numbers". I'm hoping by doing this, I can make sure that what I'm
being invoiced is really what I have received.

Vendor Invoice Record Our
Record
4229626
4229626
3580323
3580323
1452987
9875871
9875871

Well, word wrap certainly ate that reply... but I think I get the idea <g>.

Create a new Query using the "Unmatched Query Wizard". This will let you find
all the records in one (imported) table which have no match in the other
table.

John W. Vinson [MVP]

 

[Gary Crisp]

Thank-you. I have one more question, thoough. I am not experienced with
Access, so some of this is over my head. Can you walk me through this? If I
understand correctly, I should make sure that both files are imported in.
Then run the "Unmatched Query Wizard".