>>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)