Importing from Excel: indexed means? (1 Viewer)

[Espinoza84]

Hi I am importing an excel sheet as a table.

I get an option called: Indexed
what is the difference between choices: No, YES(duplicates ok), YES,(no dups)

can someone clarify this for me please, thank you.

 

[MSAccessRookie]

An index is a tool used to access the database more efficiently. If a column is used frequently in Joins, then indexing it may make access to the data faster.

No = Do Not Index this column.

Yes, (no dups) = Index on this column, and do not allow any duplicated values in the column. This is often used for Primary Keys.

Yes, (duplicates ok) = Index on this column, and allow duplicated values in the column as well.

A review of the Excel Data can help to determine which of the "Yes" options to choose.