>> So - I guess that begs the next question - how can I find out EXACTLY
>> what Schema & XML formats are supported by VFP??? Or - could it  
>> simply
>> be that VFP can't handle a schema that is like 4 levels deep?
>
> Not sure exactly what VFP supports but it looks like you will need to
> use something like MSXML to import this:
> http://msdn.microsoft.com/en-us/library/ms763742.aspx

I had a situation like this, except I couldn't get a schema file. The  
XML files defied all attempts to decode them with xmltocursor() or  
any of the VFP stuff. After creating a few head-sized holes in my  
wall, I figured that everything else I had seen from the programming  
shop that produced the XML bore the stench, er "stamp" of Redmond, so  
I cheated. I used automation to open the file in Excel and save it as  
a DBF. All of the defaults in Excel converted the XML perfectly, and  
the DBF suited my purposes just fine.

I'm sure the next release of Excel will break it, but for now: it  
works, the client is happy, and I am happy to have this pig off of my  
lap.

Ken

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1bc5f5ad-f1f5-4cd5-82c5-9a29f68f9...@information-architecture.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to