Removing duplicates & printing uniques

[sp3cialed]

Hi everyone. I'm new to access. I currently have an excel sheet that is over 1 million rows of words. When I first began this job i didnt think i would need to work in Access or a DB, but now it seeems i do. I was wondering if i could get a quick tutorial doing something very simple.

-I have a master excel sheet (A)
-then over a few days i collect a few tens of thousand more keywords and put it into sheet (B)

All I want to do is:
-compare sheet A with sheet B
-remove words in B if already in A


-print out the unique words in sheet B (non duplicates)
-Lastly uniques of sheet B added to A

Any help would be awesome!

[June7]

Remove duplicate words from sheet B, check this article http://office.microsoft.com/en-us/ex...001034626.aspx

Also refer to this article http://support.microsoft.com/kb/213367

Assuming both sheets are in the same workbook and the data are in column A of both sheets.
Copy this formula to cell B1 of sheet B then copy it down the column:
=IF(ISERROR(MATCH(A1,Sheet1!$A:$A,0)),"No","Yes")

Now sort or filter sheet B so rows with No are all together. Then copy/paste to sheet A.

Anything more sophisticated will require VBA code.

Do you want this data in Excel or Access? Excel has row limit of 1048576. Access is limited by storage capacity of 2GB.

Import the sheets to Access tables and different manipulations can produce the desired results.