| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.dotnet.framework.adonet,microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.dotnet.framework.adonet,microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.dotnet.framework.adonet,microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table: Limited nr of Calculated fields to show? | Excel Worksheet Functions | |||
| Inserting a CR into a text string | Excel Discussion (Misc queries) | |||
| inserting data in excel limited to 255 kar? | Excel Discussion (Misc queries) | |||
| Inserting a decimal from the right of a string | Excel Discussion (Misc queries) | |||
| Text in pivot table limited to 255 characters | Excel Discussion (Misc queries) | |||
Hybrid Mode
