Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel 2K3 and VFP xmldata
Message
From
23/05/2005 16:21:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Excel 2K3 and VFP xmldata
Miscellaneous
Thread ID:
01016884
Message ID:
01016884
Views:
63
Hi all,
This is actually more of an Excel question. I'm hoping there is someone that can help me out.
1. I created an xml file in VFP using the command:
use myTable
cursortoxml("myTable", "d:\temp\myTable.xml", 1, 512, 0,  "d:\temp\myTable.xsd")
2. I opened the xml in Excel 2003. From Data->XML->XML Source menu, I dragged the myTable root node into the excel sheet.
3. Went to Data->XML-Refresh XML Data menu option to load the data.
4. Made changes to loaded data.
5. Question: How do I update the XML file with the changes I've made?
5.1 I cannot Export the data back to XML.
5.2 I cannot Save As xml.

Any feedback appreciated.
ramil
~~ learning to stand still
Next
Reply
Map
View

Click here to load this message in the networking platform