write excel with oledb

[Berger]

Hello

I generate and fill an excel sheet with oledb. My problem is that I have to
write more than 255 chars but I can´t find an datatype which I can use. I
have tried datatype char,text,memo all witm max 255 chars:(
Exist another datatype which I can use?

thx for help

Björn

PS: Example code

OleDBConnection myConn = new
OleDBConnection("Provider=Microsoft.Jet.OLEDB.4.0; Excel
8.0;DATABASE="+this.destination+"; HDR=YES;Extended Properties=Excel 8.0");

myConn.Open();

OleDBCommand myCommand = new OleDBCommand();

myCommand.Connection = myConn;

myCommand.CommandText = "CREATE TABLE "+piLingoText.excelLingoData+" (test1
char(255), test2 text, test3 memo)";

myCommand.ExecuteNonQuerry;