>>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 will try the CursorToXml approach and see what the people on the receiving end will say. If they have an issue I will probably ask you to post the SP. Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham