• If there's no primary key, there's no reliable way of preventing duplicates. The first thing to do is to import from your text file into a staging table, and clean the data up in there, so that you have each column contains the same sort of information (dates, application names, etc). Then you can look at what makes each row unique, and use an outer join or some other technique to avoid importing data into your main table that is already there.

    John