Error while inserting Records to excel using OledbDriver in VB.NET , oledbdriver , excel Madurai, India
  • 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.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There's no test like production” - Anon