Export from SQL to EXCEL with long string

hi,

This is the code I use to export SQL output to Excel

EXEC SP_CONFIGURE 'show advanced options', 1; 
GO 
RECONFIGURE; 
EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries', 1; 
GO 
RECONFIGURE; 




INSERT INTO OPENROWSET ('Microsoft.ACE.OLEDB.12.0', 
'Excel 12.0;HDR=YES;Database=\\192.168.78.88\c$\Users\my.LOCAL\Desktop\Excel\my.xlsx;', 
'SELECT * FROM [test$]') 


Select F1, F2, F3....
From Table1
Where a=1

I need to have an Excel with same number of columns as in Select statement. One of the fields is comment, it is long, so I receive this error

Msg 8152, Level 16, State 10, Line 14
String or binary data would be truncated.
The statement has been terminated.

thanks