inserting data in excel limited to 255 kar?

B

Britt

Hi,

I tried several groups without succes, so i try here.
I insert strings into an excel table usind those commands:

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
 
Top