Copy more than 1024 characters to a cell
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.