Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 55
Default CopyFromRecordset fails if string 911?

I posted what I think is an elegant solution to the 911 character limitation
in Excel. Perhaps it will work in Access as well.

http://support.microsoft.com/newsgro...sloc=en-us&p=1

"Ken Valenti" wrote:

When using the CopyFromRecordset method, it fails if the lenghth of text
exceeds 9XX.

Using ADO to connect to an Access 2003 database. Fields are defined as
"memo" in Access (unlimitted length).




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CopyfromRecordset MattShoreson[_67_] Excel Programming 2 March 15th 06 01:36 PM
CopyFromRecordset Ernst Guckel[_4_] Excel Programming 3 May 1st 05 08:03 PM
copyfromrecordset fails after upgrade to XP and Excel 2003 [email protected] Excel Programming 0 April 28th 05 06:06 PM
CopyFromRecordset does nothing E Harris Excel Programming 5 January 8th 04 04:29 PM
Copyfromrecordset Bug ? news.btx.dtag.de Excel Programming 1 August 1st 03 07:44 PM


All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"