>>>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.
>>
>>
>>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