[xml-dev] Need help reading xml data into scalc

[Richard A. DeVenezia]

I have received an xml file and don't know the rituals needed to get to
appear in calc

The file looks like this:

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema";
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="Table">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="MemberID" type="xs:int" minOccurs="0" />
                <xs:element name="LastName" type="xs:string" minOccurs="0"
/>
                <xs:element name="FirstName" type="xs:string" minOccurs="0"
/>
                <xs:element name="MiddleName" type="xs:string" minOccurs="0"
/>
                <xs:element name="LeagueRating" type="xs:short"
minOccurs="0" />
                <xs:element name="Rating" type="xs:short" minOccurs="0" />
                <xs:element name="ExpirationDate" type="xs:dateTime"
minOccurs="0" />
                <xs:element name="Sex" type="xs:string" minOccurs="0" />
                <xs:element name="Email" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <Table>
    <MemberID>906675</MemberID>
    <LastName>Abraham</LastName>
    <FirstName>Byron</FirstName>
    <MiddleName />
    <LeagueRating>663</LeagueRating>
    <Rating>0</Rating>
    <ExpirationDate>2007-07-25T00:00:00-07:00</ExpirationDate>
    <Sex>M</Sex>
    <Email />
  </Table>
... lots more <table> for each row
</NewDataSet>

Any help or pointers is appreciated.

TIA,

Richard A. DeVenezia

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]