When an XL8 spreadsheet is saved in Excel 2007, it is no longer compatible with VFP's IMPORT command. Note: I'm not talking about the new XML format, I'm talking about saving the document as an "Excel 97-2003 Workbook" or while the document is in "Compatibility Mode". There has been some discussion on this before, but has anyone found a way to get this working? I know there are alternatives to getting the data (automation, etc.), but I imagine there is a lot of IMPORT code out there, and this is going to be a big deal. Microsoft has said they won't fix this, referring to it as a "new" format, but it's not really new. Either the Excel or Fox team should take a look at this. Sergey reported the bug at the link below. Maybe more votes will make a difference:
https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=256811As an alternative, I thought Sedna was going to include support for the new 2007 formats, but I don't see anything along those lines.