Cannot Import XML Spreadsheet 2003 with XML Data Source
 

One of the features of Excel 2007 I have truly been enjoying is the Import
XML Data Source feature (in the Data tab of the Ribbon). It has made
reviewing and updating information of web-based information a LOT easier.

Unfortunately, when attempting to import a Microsoft Excel XML Spreadsheet
2003 XML File, I get the error that "The specified XML source does not refer
to a schema." Excel, as it says, attempts to create a schema, but fails
miserably.

If I open the file normally using the Open command, the file opens without
any issues. This doesn't do me any good, though, as I am wanting to be able
to manipulate the data in other Worksheets of a new Workbook.

Upon reviewing the XML, I noticed that Microsoft takes a VERY different
approach to rendering XML data.

My question is, how can I use the XML Data Import feature with XML
Spreadsheet 2003 files so that I can map the XML data properly in a new Excel
Workbook?