Error while inserting Records to excel using OledbDriver in VB.NET

• • Reply

  12 years ago

  by bhuvannrk

  bhuvanradhakrishnan

  , India

  Joined 12 years ago
  Hi All, I'm trying to insert data to excel sheet using oledbDriver. The excel sheet contains 40 columns and I'm trying to insert 820 records. Out of the 820 records, I have problem with 2 records. Those records contains 290 chars in a column. I'm getting the following error: [B]"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."[/B] I'm using oledb parameters to insert records and the datataype for the specified column is (oledbType.Varchar,1000). I also have tried with Oledbtype.LongVarchar and OledbType.LongVarWChar But still I'm getting the same error.
  Report abuse