I need to match 3 fields for duplicate

[Voodoo223]

I am exporting an Oracle report to excel, and using an Access macro to import into a table.
The records contain some duplicate info that I do want to capture, but I don't want to import the same records. (I import the file on one day, and someone comes in and imports the same file later).
This would work if I could get the table to not duplicate if three of the fields are the same as an existing record. I tried using the index, but it reconizes any/all of the fields that duplicate.
Any help would be appreciated.

 

[neileg]

You need to create one index that includes all three fields. Higlight the three fields in table design view and click the primary key button.

 

[Voodoo223]

Do I set all 3 to index (no duplicates)?

If I do that, it will reject the record if there are dupes in any of the 3 fields.
I need it to reject only if all 3 fields are the same.
I appreciate your time.

 

[neileg]

From Access Help:

Create a multiple-field index
Open the table in Design view.

Click Indexes on the toolbar.

In the first blank row in the Index Name column, type a name for the index. You can name the index after one of the index fields, or use some other appropriate name.

In the Field Name column, click the arrow and select the first field for the index.

In the next row in the Field Name column, select the second field for the index. (Leave the Index Name column blank in that row.) Repeat this step until you have selected all the fields you want to include in this index. You can use up to 10 fields.
Note The default sort order is Ascending. Select Descending in the Sort Order column of the Indexes window to sort the corresponding field's data in descending order