Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert excel to DBF file
Message
From
24/07/2017 14:43:13
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01652806
Message ID:
01652818
Views:
64
>>Instead of exporting to CSV, can you export to Excel's XML 2003 format?
>
>I have converted the sample .xls to the XML 2003 format. How would I import it into a DBF/cursor?

I don't know Greg's library, but I'll suppose it will give you the possibility to read the value of a specific cell. The records in your worksheet seem to be grouped in a 10-row pattern, so it would be a matter of stepping through 10 rows at a time, and fetch what is in a specific relative cell in each group.

I'm heading home, now, and given some spare time, maybe I put forward a different approach, since you have the possibility to save the data into a self-contained XML file.
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform