SQL Server can process simple XML directly. Check Re: Datetime value in table created with openxml() become nu Message #1018922, for example.

>What is the easiest way in VFP7 to take an existing XML document and inserting the values into a table. Right now I am using XMLTOCURSOR, and spinning through the table and inserting the values into a stored procedure, but that isn't going to work if a field isn't included in the XML document. Any suggestions?
>