>>Aleksey,
>>
>>As I now understand, Visual FoxPro doesn't support versions of Excel beyond XL8. like in the new Office 2007.
>>
>>Since both Excel and Visual FoxPro are MS products, can we expect a solution in a service pack?! As of this moment I have not a single client who uses Office 2007, but that will most likely change in the course of this year.
>>
>>See also: Re: Import from Excel in Office 2007 Thread #1191678 Message #1191724
>
>Hi Peter,
>
>To the best of my knowledge, there are no plans to enhance IMPORT command to support new file formats. IMHO it was a mistake to add support for importing Excel documents the way it was done in VFP. The import isn't performed using any standard API, instead the knowledge about certain file formats is hard coded into VFP's code. A file is read as a byte stream and is interpreted by VFP itself. You can imagine that as a result, the cost of adding and testing support for new file formats or rewriting the code to use a standard API is very very high. It doesn't fit into an SP. There is a number of standard APIs that can be used to read Excel documents: ODBC, OLEDB, Automation of Excel.

Aleksey,

Thanks for the answer. So, there may well be a compatibility issue soon (or already). If it is true that the regular Save feature of the new Excel produces an incompatible file format, and if an existing vfp-application uses IMPORT to import such an xls-sheet, then that existing app will gonna crash, right? Are you saying here that the developer has no other choice than, either to change the code in the app, or to instruct the suppliers of the xls-sheets to deliver an older Excel file format?