Create an Autonumber column in a table

[Astello]

How do I add an autonumber column to an already existing table?

 

[John Vinson]

How do I add an autonumber column to an already existing table?

If you want to control the sequential order of the autonumber values,
the best solution is to copy your table, *design mode only*, to a new
table; add an autonumber field to the (empty) table, in table design
view; run an Append query to append all the data; drop all
relationships to the old table and build new relationships to the new
one.

John W. Vinson[MVP]

 

[Astello]

I messed with this table for so long that I'm not even sure what to
tell you I came up with, but I know I had too much data. There were
almost 1 million lines combined, so I put them into notepad (as scrappy
as that sounds) and imported the whole thing at once, letting Access
add the primary key upon import.