You can create XML data from a Microsoft Excel 2003 worksheet or workbook, but you'll need to do some manual steps to get the data to conform to valid XML format.

I'm trying to take an XML document and dump the contents into a table. Not as XML using the SQL Server 2005 XML datatype, but as the parsed data values into a table with a column for each element ...