VBA CopyFromRecordset won't print all collumns
My problem is that one column in My ADO recordset won't print to worksheet when i use CopyFromRecordset RS. I believe the reason is that this column have datatype text in the database im getting it from, but i don't see the reason why i can't print it. I can see that the coulumn is saved in the dataset when looking in the window; Locals/fields/item7, and if i saves dataset in a string with rs.getstring all columns gets printed to string.
It works if i convert datatype to Varchar(255) in the SQL with "Cast(column as varchar(255)". But the column can be up too 1000 chars, so varchar (255) won't be large enough to show the entire text. Help please :)
