Help? One Table, Finding Unmatched

[geofftke]

I am as new as new gets to Access. I was told it (I have Access 2007) is the perfect tool to accomplish the following:

I have a 2 column, 4,000 row spreadsheet in Excel. I want to remove any duplicated rows (both of them) and view ONLY those rows that do not have a duplicate at all (unmatched).



If someone has the patience to explain this to me, that would be great.

-Confused Beginner

[June7]

Link to or import from the Excel worksheet. Links can be queried just like a natural table.

Try:

SELECT * FROM tablename WHERE IsNull(DLookup("field2", "tablename", "field2='" & field1 & "'"));