>>Hi,
>>
>>I need a way to send some of the data from a VFP table(s) to a customer for importing into their SQL Server. I am thinking of outputting data from the table(s) into XML file. Is CURSORTOXML() sufficient to create such an XML? Or XML Adapter class is preferred?
>>
>>TIA.
>
>CursorToXML is sufficient. I recently implemented an SP using XML as a source. I can post it if you want.
>Although if you want them to use SSIS to import the data, may be Excel or CSV will be better.
I would like to see how that works, because in some situations I can imagine that will be much faster to process than separate SQL passthrough statements.
Christian Isberner
Software Consultant