Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Excel Spreadsheet to Cursor
Message
From
12/07/2012 18:19:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Convert Excel Spreadsheet to Cursor
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01548424
Message ID:
01548424
Views:
92
We have an Excel 2007 spreadsheet that we need to turn into a cursor. Excel 2007 doesn't support Save As DBF anymore so I need a different solution. My first thought was to save it as an XML file and then use VFP to create a cursor. Accordingly I tried.......
=XMLTOCURSOR(GETFILE("xml"),"myCursor",512)
This "works" in the sense that a cursor gets created. Unfortunately the cursor contains the Document Properties (LastAuthor, Created, Lastsaved, Version, etc.)

Is there a way in Excel to Save as XML but without this information?

Is there a way in VFP to bypass this information and right to the "real" data?

Is there a better approach?

Thanks to all...........Rich
Next
Reply
Map
View

Click here to load this message in the networking platform