Adding Primary Key to existing table

[herbc0704]

I have a table that is updated from an Excel Spreadsheet. This table does not contain a field for primary key, is there a way to add a primary key field to an existing table.

I need to do this because when the table get updated, there are times that the update is either wrong or contains errors and the data has to be deleted. I am thinking a primary key makes it easier to locate new information added and then deleted if need be.

 

[Joe4]

You should just be able to go into the Design View of your table and add an Autonumber field and use that as your Primary Key.

 

[herbc0704]

Thanks Joe,

I knew it had to be that easy, so easy I would have never thought of that.