inserting string into excel table limited to 255 kar??

  • Thread starter Thread starter Britt
  • Start date Start date
B

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
 
thanks britt...ill hang on here cause i like to fish the real
solution....hope u dont mind....
 
Back
Top