Hi!

The most simple solution is given by Sergey. When you require to convert the entire string to Excel anyway, there are complex solutions:

splitting one record from the result set to several reacords each containing text with 254 chars

or use OLE Automation to convert data without memo field, open Excel file in the Excel using OLE Automation and programmatically fill data in the chart from VFP.

>I changed a textbox with data type c(20) to an editbox with data type m(4) so the user could add a longer description. I use the following SQL to create a cursor that is used to create an Excel file (COPY TO (filevariable) TYPE XL5)
>
>SELECT log,requestor,division,memdate,datexxrecd,divrefnum, ;
> section,ALLTRIM(substr(comments,1)) AS comments,status, ;
> rettodate,retfromdat,indate,datecomp ;
> FROM flair1 ;
> WHERE STATUS=0 ;
> INTO CURSOR samData ;
> ORDER BY division,LOG
>
>Now the memo field "comments" only contains the first letter of the string in the memo field. How do I get the whole string so I can send it to Excel or what is the best way to pass memo field to Excel?
>
>Thanks in advance, Chuck