Thread: CopyFromRecordset fails if string 911?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default CopyFromRecordset fails if string 911?
Sounds like this might be a limitation in Excel:

http://support.microsoft.com/kb/818808/en-us

You may receive a "Run-time error 1004" error message when you
programmatically set a large array string to a range in Excel 2003
--
Regards,
Tom Ogilvy


"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 With QuoteReply With Quote