Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel 2K3 and VFP xmldata
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
01016884
Message ID:
01016992
Views:
17
This may help you...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_OFEditingXMLWordExcel.asp


>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform