Wrox Programmer Forums
|
BOOK: Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, MySQL ISBN: 0-7645-8437-5
This is the forum to discuss the Wrox book Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL by Wallace B. McClure, Gregory A. Beamer, John J. Croft IV, J. Ambrose Little, Bill Ryan, Phil Winstanley, David Yack, Jeremy Zongker; ISBN: 9780764584374
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, MySQL ISBN: 0-7645-8437-5 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 15th, 2006, 12:39 PM
Friend of Wrox
 
Join Date: Apr 2006
Posts: 160
Thanks: 0
Thanked 0 Times in 0 Posts
Default inserting data in excel limited to 255 char.?

Hi,

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









Similar Threads
Thread Thread Starter Forum Replies Last Post
Big challenge here! How to convert char* to char^? samiswt Visual C++ 2005 1 November 30th, 2007 09:09 PM
Invalid conversion from 'char*' to 'char' deuxmio C++ Programming 3 December 8th, 2006 07:56 AM
How do I compare my char data to Dataset kau_shuk SQL Server 2000 0 September 7th, 2006 04:53 AM
Convert Char Data Type to smalldatetime rylemer SQL Language 3 March 3rd, 2005 03:13 PM
SQL statement limited to 255 chars Mikeopolo Excel VBA 1 February 18th, 2005 09:20 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.