Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update data in Excel | New Users to Excel | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |