Reading XML Excel into a dataset

[Alex Shirley]

Hi

I'm still banging my head on how to import an Excel XML spreadsheet
into a dataset. The code will work for standard XML files, but not XML
files made with Excel (I get 'Specified cast is not valid' with the
xmlread statement).

What do I need to do? ... transform it perhaps? How?
Or is there a better way?

Please help... I'm getting as despirate as the Democrats in the recent
US election! Any help of any substance will do! ... for I am lost.

The code is listed below.

Many thanks!!!

Alex

----->

-- CODE I HAVE TO READ XML FILE --

Dim thisdataset As New DataSet
Dim xmlfilename As String = "myfile.xml "
Dim fsReadXml As New System.IO.FileS tream (xmlfilename,
System.IO.FileM ode.Open)
Create an XmlTextReader to read the file.
Dim myXmlReader As New System.Xml.XmlT extReader(fsRea dXml)
' Read the XML document into the DataSet.
thisdataset.Rea dXml(myXmlReade r)
' Close the XmlTextReader
myXmlReader.Clo se()

-- Beginning of XML Excel Spreadsheet file I am reading (cut it
short)--

<?xml version="1.0"?>
<ss:Workbook xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:c="urn:sc hemas-microsoft-com:office:comp onent:spreadshe et"
xmlns:html="htt p://www.w3.org/TR/REC-html40">
<x:ExcelWorkboo k>