An OO import filter is hard work for the smart, I'm told, not being one of those. An XSL transform to a file format scalc understands (try CSV, it's simple) is not so bad.
BTW, what you have is the xml put out by a MS SQL Server data base. You shouldn't get the idea that all xml is so complex. The complexity comes more from data base issues than from the content. Good Luck, Gannon --- Oliver Brinzing <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, > > you can try to build a xslt import filter ... > > http://www-128.ibm.com/developerworks/xml/library/x-oocalc/ > > Oliver > > Am 09.10.2007 17:19 schrieb 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] > > > > > - -- > > GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 > 4A45 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFHC6l3TiyrQM/QSkURAjAkAJ0ceutwqXq6eoMeXCXD0Wuce+puIwCffaMi > grIpIzXxiWRRtkQBr1bttcY= > =PZtY > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ____________________________________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
