Importing Excel XML into dataset

[postings]

Hi - can you help please?
Please review the following straightforward code which works fine with
ordinary XML files.

----------------------------------------------------------------
Dim originalxmlsource As New DataSet
Dim xmlfilename As String = Request.PhysicalApplicationPath _ &
"myfilename.xml"
originalxmlsource.ReadXml(xmlfilename)
MyDataGrid.DataSource = originalxmlsource
MyDataGrid.DataBind()
----------------------------------------------------------------

In actuality what I really need to do is import an Excel XML file,
which was originally generated by Office Web Components (Excel 2002).
OWC would only allow me to Export in Excel XML, rather than native
Excel format.

If I try to use the above code using Excel XML I get a "Specified cast
is not valid" error.

So my question is how can I neatly import Excel XML into a dataset?

If I can't I was wondering if there is any way of transforming the
Excel 2002 XML file itself to native XML (i.e. strip out the garbage)
before it got read in....

Many thanks!

Alex