>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