Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create XML for import into SQL server?
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01521495
Message ID:
01521501
Views:
56
>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform