>>>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.
>
>Perfect! Thanks Sergey!

I thought exactly the same, actually. Just didn't have time to answer right away.

BTW, did you solve your other problem already?