title: Problem using oledb datatypes to write data to excel sheet
body: <p>I am trying insert some data into excel sheet using oledb dataadapter which is obtained from MYSQL Db.This data obtained from mysql db contains very long texts whose datatypes in MYSQL have been defined as(Varchar(1023),Text,Longtext etc).When I try to pass these to the oledb Dataadapter I tried to use oledb.VarWChar,oledb.LongVarWChar with size 5000 and so on.But I am getting the following exception when I try to run da.update(...) command.</p>
  
  <p><strong>The field is too small to accept the amount of data you attempted to add.  Try inserting or pasting less data</strong></p>
  
  <p>I am having trouble understanding what datatypes with what sizes should I use in oledb to map to these long text values.</p>
  
  <p>Could someone please help me with this?</p>
  
  <p>Thanks.</p>