Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxPro to Excel problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00469794
Message ID:
00469893
Views:
22
The strange things are:
From VFP it is possible to import and to copy to .. xls/xl5. And it does not translate records above 16,384. However, from EXCEL (even if use excel automation from VFP) it is possible to translate 65535 records:
..Workbooks.Open("FoxPro.dbf")
..ActiveWorkbook.SaveAs("c:\hi.xls")




>>Ok, so the problem is not Excel, but that vfp cant
>>export more than 16,384 lines at once?

>No, the problem is Excel -- but not the current version. VFP exports in XL5 >format, which has this file-format restriction. It can read XL8 format, but >not write to it.
Previous
Reply
Map
View

Click here to load this message in the networking platform