>I have imported an Excel file into a SQL table. There is nothing unique in the data, so I want to add an Id column and populate it with 1 to the record count.
>
>How do I do this in SQL 2005?

ALTER TABLE and add int column with IDENTITY attribute.