Hi, Roy.
>I would like to create a spreadsheet from a foxpro table. The easiest way for me is to use the COPY TO command but the problem is that the memo fields don't go over. What is the easiest way to do this? I want to put the memo into one cell.
You can get the data you need and convert the memo to a char field before exporting, using somthing like:
select field1, field2, alltrim(memofield3) as field3...
Char data is easily exported (until 256 characters)
If you need to handle bigger memos, you need to use automation. In than case, read this article from Himal Zonneveld:
http://www.utmag.com/September2002/Page45.aspHope this help,