>Do you know of any good examples using VFP to create XML, send it to SQL to have the data inserted into a table?
I have just this for one of my GLGDW 2002 sessions.
There are various options for creating the XML using VFP. That should be easy to find. At a minimum you can use CURSORTOXML().
You can send the XML to a stored procedure as a TEXT or NTEXT parameter. Just watch the encoding. If you use UTF-8, you'll have to use the TEXT datatype of sp_xml_preparedocument will raise an error.
The BOL has some really good examples of using OPENXML(). Do you have any specific questions.
-Mike