View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Britt Britt is offline
external usenet poster
 
Posts: 2
Default inserting data in excel limited to 255 kar?

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