>>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

Mike,

thanks. I followed those basic steps and couldn't seem to select the data I wanted out of the XML. When things calm down at the office, I will try to put up a sample code of what I was doing. Perhaps you will spot my mistake.

Thanks,
BOB