Reply to thread

Message: [QUOTE="Pat Hartman, post: 2558211"] Sorry, I misunderstood your first post. You cannot add a key to a text file and even if you could, Access wouldn't allow the key to be created if the table already contained records that violated the uniqueness of the key. So you have two options that I can see: 1. Import the data into a table that does have a PK defined. The records with null values in the PK will not be appended. 2. A better choice - Use selection criteria in your queries to ignore rows where the PK field is null. [/QUOTE]