Problem in pulling data from database due to length of record

Hello there,

I have done VBA code in/using Excel Macro. Code is correct because out of 7 columns 3 columns are pulling rest of them are not. As primary investigation, Length of the 4th column data is bigger so, it is unable to pull in Excel using VBA.


Because by other way of pulling records in excel like from Data>> From Other Resource>>From SQL server this way all the records are pulling but using VBA/MACRO record length is the issue.

Can someone please help how to make excel cell big so that sql record can fit into that?