>Thanks Sergy -
>
>I've been doing some exploring and testing and I've beeen able to make a few of these xml things work but now I have a problem with the real xmldatafile I want to work with. The xmltocursor function loads all of the data into a single huge memo field (one record). I know this has something to do with the schema but I can't seem to figure it out. The following is the front end of the xml file. It looks like it contains data for several related tables although you won't see that with this small sample.
>
This thread: #904549 "Processing an XML file to VFP cursors", is a great VFP/XML Thread. It also goes into the Document Object Module.


>I'm not sure but it looks like the file references a schema that is located out on the web but vfp doesn't automatically get it and use it? Do I need to d/l a schema and have it available locally when I run xmltocursor? Sorry this is so basic but this is a totally new area for me. Thanks for any help or insights you can provide.
>
>Here's the first few lines of the file:
>
>**************************************************************
>

><?xml version='1.0' encoding='utf-8'?>
><SOAP-ENV:Envelope
&gt;xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'
&gt;xmlns:xsd='http://www.w3.org/2001/XMLSchema'
&gt;xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
&gt;xmlns:SOAP-ENC='http://schemas.xmlsoap.org/soap/encoding/'>
><SOAP-ENV:Body>
><ns1:downloadResponse
&gt;SOAP-ENV:encodingStyle='http://schemas.xmlsoap.org/soap/encoding/'
&gt;xmlns:ns1='urn:TMSWebServices'>
><xtvdResponse xsi:type='ns1:xtvdResponse'>
><messages xsi:type='ns1:messages'>
><message>The endTime you specified 07:00:00Z is not in a valid format, and has been corrected to a default value.</message>
><message>The endTime you specified was invalid and has been corrected to 2004-11-17T07:00:00Z.</message>
><message>Your subscription will expire: 2005-01-29T23:55:24Z</message>
></messages>
><xtvdDocument xsi:type='ns1:xtvd'>
><xtvd
&gt;from='2004-11-12T07:00:00Z'
&gt;to='2004-11-17T07:00:00Z'
&gt;schemaVersion='1.3'
&gt;xmlns='urn:TMSWebServices'
&gt;xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
&gt;xsi:schemaLocation='urn:TMSWebServices http://docs.tms.tribune.com/tech/xml/schemas/tmsxtvd.xsd'>
><!-- xsi:schemaLocation='D:\foxpro\xml\tmsxtvd.xsd' -->
><stations>
><station id='10021'>
><callSign>AMC</callSign>
><name>AMC</name>
><affiliate>Satellite</affiliate>
></station>
><station id='16331'>
><callSign>ANIMAL</callSign>
><name>Animal Planet</name>
><affiliate>Satellite</affiliate>
></station>
><station id='10035'>
><callSign>ARTS</callSign>
><name>A & E Network</name>
><affiliate>Satellite</affiliate>
></station>
><station id='18332'>
><callSign>BBCA</callSign>
><name>BBC America</name>
><affiliate>Satellite</affiliate>
></station>
><station id='10051'>
><callSign>BET</callSign>
><name>Black Entertainment Television</name>
><affiliate>Satellite</affiliate>
></station>
><station id='10057'>
><callSign>BRAVO</callSign>
><name>Bravo</name>
><affiliate>Satellite</affiliate>
></station>
><station id='21855'>
><callSign>BYUTV</callSign>
><name>BYU-TV</name>
><affiliate>Satellite</affiliate>
></station>
>