Importing Excel Files

T

Tony

Is there anyway when imoprting an Excel file to keep from putting duplicate
records in my database? Thanks for any help.
 
S

Sprinks

Tony,

In table design view, create an index on the field or combination of fields
that you wish to be unique (View, Indexes). Set the Unique property to Yes.
For a multiple-field index, leave the Name column blank except for the first
row.

Sprinks
 
Top