Invalid value for cell

[GeorgeBC]

Hi,

I updated my db system from access to sql 2005.
But, i can not add new recors to database.
I'm receiving this error:

"""Invalid value for cell (row 3914, column 2).
The changed value in this cell was not recognized as valid.

.Net Framework Data Type: Int32
Error Message: Input str?ng was not in a correct format.

Type a value appropriate for the data type or press ESC to cancel the change."""

It can not open new id number. DataType was Auto Number in Access. Which can I select in SQL 2005?

Thank you.

 

[SQLSister]

Identity fields are what does autonumbering in SQL Server. Look up how to create them in Books Online.

Questions about posting. See faq183-874