General information
Category:
COM/DCOM and OLE Automation
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only