User77

User77

  • NA
  • 52
  • 26.3k

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

Oct 28 2016 7:22 AM
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

Answers (2)