inserting string into excel table limited to 255 kar??

[Britt]

Hi,

Maybe not the right newsgroups, but it's excel and ado.net, so ....

I insert strings into an excel table usind ado.net like:

Dim oConnection As OleDbConnection
Dim sConnectionString As String
oConnection = New OleDbConnection()
Dim comd As OleDbCommand
sConnectionString="
sConnectionString="Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
c:\mydb.xls; Extended Properties=Excel 8.0;"
oConnection.ConnectionString = sConnectionString
oConnection.Open()
sql="insert into data ...... "
comd = New OleDbCommand(sql, oConnection)
comd.ExecuteNonQuery()
oConnection.Close()

My problem is that all strings (coming from asp.net textarea controls) are
limited to 255 karakters in excel.
Any way to solve this?

Thanks
Britt

 

[rml]

thanks britt...ill hang on here cause i like to fish the real
solution....hope u dont mind....

 

[Britt]

don't understand what you mean ..

thanks britt...ill hang on here cause i like to fish the real
solution....hope u dont mind....