compare 2 columns 1

[codrutza]

Could you please help me with this?
I have this in Excel

col1 col2
aaa aaa
bbb
ccc ggg
ddd nnn
ccc
eee ppp
fff bbb
nnn

I am importing it in MicrosoftAccess in a table and I want to pick only the records from col2 which are not in col1, as

ggg
nnn
ppp

Is it possible to write a query to accomplish this?
I have tried to import the 2 separate columns in 2 separate tables, but still I don’t know how to write a select.
Or maybe there is a way to do this in Excel?
Thanks

 

[fneily]

You can do this in Access, but you wouldn't because you wouldn't have duplicate data in a table. Research Normalization.
You would do this in Excel. If you do a search in the Microsoft Office forums, you'd find a few solutions, such as:
thread68-1234731

 

[codrutza]

ok, thanks