>>>>Hi All:
>>>>
>>>>I am passing data from VFP tables to a programmer, by COPYing DELIMITED to a text file. He then imports the data from the text files into SQL Server.
>>>>
>>>>I notice, however, that the COPY command does not copy memo fields. How do I do that?
>>>>
>>>>Thanks,
>>>>
>>>>Yossi
>>>
>>>The problem is that a memo could contain stuff that will corrupt a DELIMITED, or any other line based format
>>>
>>>One problem (just an example)
>>>
>>>Those text formats are one line - one record. If a memo contains a line break, how should that be handled? Also a single memo could be a bit large
>>>
>>>I would try to use XML to transport the data, the other guy should be able to deal with it.



select yourtable
locate
CURSORTOXML("yourtable", "myXMLFile.xml", 1, 512, 0, "1")
the last parameter adds the the file schema. very important when passing data to 3rd parties

Peter



>>>
>>>
>>>HTH
>>>
>>>Lutz
>>
>>Lutz,
>>
>>Thanks! However, I'm not familiar with transporting the data with XML. Could you point me in the right direction?
>
>Never mind. I think you can do it with CURSORTOXML