Consulting

Results 1 to 2 of 2

Thread: Copy more than 1024 characters to a cell

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Copy more than 1024 characters to a cell

    Hi,

    I'm trying to copy data from a database into an excel.
    However, the problem is for certain columns in my database,
    the number of characters exceeds 1024.

    So on copying it to an excel, it gives me the "recordset" error.

    Can someone please give me a macro of how I can copy and paste
    more than 1024 characters into a cell in excel.

    Thanks
    Justin

  2. #2
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,776
    I can't reproduce this error.
    Playing around with =REPT("X ",2000) in A1 and =LEN(A1) in A2,
    copying, pasting, pastevalues all handle the 4000 characters.

    What version of Excel are you using?

    Have you looked at the DataObject, perhaps the clipboard could be parsed before it is put into cells.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •