Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Better way to code Excel automation?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01313820
Message ID:
01349794
Views:
25
Check Importing data from a Microsoft Excel 2007 workbook using Visual FoxPro 9.0

>
>We get an Excel 2007 file with 5 sheets of different accounting data. I need to put each of them into a DBF. Since MS deprecated the Excel saveas DBF3 or DBF4, I have to find another solution. I have made saving to a CSV file work for data I know the structure of. For data I do NOT know the structure, I thought using XML would be straight forward using XmlToCursor. But once again, MS has every fileformat for the Excel saveas method except XML. If there is a better solution I am all ears. I do not know about XMLSS, but will check it out. Do you have any tips to shorten my learning curve?
>
>I am very new to the Office 2007 automation process. I have several solutions using Office 2003 and before, but 2007's object model is confusing. I have not used XML but for one app. I hope the solution is NOT building the Excel to XML line by line. I feel that would be very primitive compared to the object models available. We are not using .Net for a solution, only VFP and the Office object model.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform