Loading

change data base column data type id is 'int' to string

User77

10y932.NET

Hi, In my wed application, i have one table in that i took ID column as "int" data type to insert all the excel sheets to data base but suddenly it have the "5-MA" the ID value it throws the exception like this "The given value of type String from the data source cannot be converted to type int of the specified target column." Can anyone Please help me how can i do this

Thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta10y ago
As manas said, int datatype cannot hold string value.
Goto Design view -> change the int datatype to nvarchar (max).
Then only you are allowed to store either int or string.

Do let me know if it solves your problem.
Manas Mohapatra10y ago
As your ID column is int and it will acceptonly integer value.
Butone field value is "5-MA" which is not an integer.Either make the column data typeas string type or make correct the data.