inserting string into excel table limited to 255 kar??
 

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

inserting string into excel table limited to 255 kar??
 

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

"Britt" wrote:

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

inserting string into excel table limited to 255 kar??
 

don't understand what you mean ..

"rml" schreef in bericht
...
thanks britt...ill hang on here cause i like to fish the real
solution....hope u dont mind....

"Britt" wrote:

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