Community discussion forum

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

• • Reply

  10 months ago

  by bhuvannrk

  bhuvannrk

  , India

  Joined 1 year 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.
  Post was edited on 20/01/2009 12:46:01 Report abuse