Loading an Excel 2007 file which is named .xls, not .xlsx

[mengland]

I seem to be running into problems trying to load an xlsx file which is incorrectly named as xls.

Even Excel 2003 with the extension installed has problems opening these files, however renamed to xlsx they can be opened correctly. I can also open these files with 7Zip, which leads me to believe that the files are ok, just incorrectly named.

The error message I get is "Error on reading record * 102, F6F7 Offs: 0000059F Bad Record In File"


So I'm trying to help the import by setting:

Code: Select all

ExcelFile.Version := xvExcel2007;

This doesn't seem to help, any suggestions? I have tried setting that before/after I call the Read function, and even before I set the Filename property, however it doesn't seem to work.