>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]