Excel Import: An explicit value for the identity column in table ERfailures can only be specified when a column list is used and IDENTITYINSERT is ON.

sunil123

Sir, I trying to use example of how to Import or insert Excel Sheet data and records into SQL Server 2005, 2008, 2012 using ASP.Net written by you.

Example is running fine, but when i try to use same for my requirement it generate an error message as

"An explicit value for the identity column in table 'ERfailures' can only be specified when a column list is used and IDENTITY_INSERT is ON."

What changes are rquired? Please help.

Mudassar

0 3

You need to make your column AutoIncrement so that even if you don't specify Ids it will automatically increment