importing data- find new data

[cengineer]

I would like to import data from a text file into a table and have the new data stored in a separate table. Or take two tables basically and compare the two and separate the data that is not in the old table. Does this make sense? Any advice appreciated. Thanks.

[cengineer]

Resolved it with select where not exists... thanks