Adding a unique identifier field to a table with lots of data

[adamburton]

Hi,

I wonder if someone can help with what must be an easy solution to this problem.

I have a table with 350,000 records, but without a unique identifier field. I just want a simple incrementing number field to become the primary key but dont know how to add this in. I cannot add an autonumber as there are two many records - it falls over.

Ive tried exporting it all to excel, but as well as being cumbersome, something went wrong and so I'm back to square one.

I think there must be a way to add an incrementing number either via a query or in VBA but I dont know how. Please can somebody provide a solution.

Thanks,
Adam.

 

[neileg]

Try creating a new empty table with the same structure plus an autonumber field. Then append your data to the new table.

 

[adamburton]

Thanks Neil

Thanks very much Neil. I knew it was going to be simple!!

regards,
Adam.