Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel bulk transfer
Message
From
17/04/2009 11:04:18
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
17/04/2009 11:00:50
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01395271
Message ID:
01395277
Views:
82
>>DBF files used to be a viable option for bulk transfer to Excel, i.e. transfer a large amount of data without the slow speed of setting each cell individually. The bulk transfer might be the first step; later, the Excel file is formatted with additional commands (e.g., column width, numeric format for individual columns, inserting additional header rows).
>>
>>Now, it seems that the DBF format is no longer supported by Excel 2007, so this can be a problem. What would be the recommended method for a bulk transfer from Visual FoxPro? Some other file format? Clipboard? Preferably a method that would work both with Excel 2003 and Excel 2007!
>>
>>Right now I don't have a pressing need to solve this; I was just wondering.
>
>Excel 2007 no longer supported by us than... ;)

You mean, you do use DBF a lot for bulk transfer, right?

Unfortunately, we have to assume that many users will upgrade to the new version. But indeed, "Excel 2007 is not supported" may work as a short-term solution. Just tell the clients they have to keep Excel 2003 on machines that have your program, for certain features to work. I would considert this a short-term solution, however. Eventually most users will want to have the newer version of Excel.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform