Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel bulk transfer
Message
From
17/04/2009 11:11:18
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
 
 
To
17/04/2009 11:04:18
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01395271
Message ID:
01395281
Views:
85
>>>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.

I don't have office 2007 but did you try copy ... type fox2x and open from excel?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform