Unique Entries from two files

[ashish mehra]

Hello Experts,

I am comparing two databases; first one we have sent to other department for some information which they have added viz 2 columns of data.

The first step is to check out the count of line items; I need help in reconciling the leftover entries if there are any of them.

The database contains 20 lakhs rows of data & we are using Excel 2007 version & Access 2007.

I am attaching a sample workbook contains 3 sheets; Sheet1, Sheet2 & Require Output

Sheet1 contains 20 line items
Sheet2 contains 15 line items
Require Output Sheet contains 5 missing line items; these need to be tracked.

Regards,
AM

 

[Nebu]

Hi:

Use the following SQL in your access query to get the desired result.

SELECT Sheet1.* FROM Sheet1 LEFT JOIN Sheet2 ON Sheet1.[Personel Number] = Sheet2.[Personel Number]
WHERE Sheet2.[Personel Number]IS NULL

I linked your Sheet1 and Sheet 2 and ran an umatched query.
Thanks

 

[ashish mehra]

That's works perfect.

Thanks