The XL8 is Excel 97 format. That's what user should select in Save AS dialog. VFP IMPORT/APPEND FROM commands will not recognize any later XLS formats.
>When we save an XLSX as XLS in Office 2007, the resulting XLS cannot be imported in Foxpro using "Import from .... " type XLS (or XL5 or XL8)
>Foxpro says : "Microsoft Excel file format is invalid"
>
>Anybody any idea what's going on?
>Our customers have to import on a very regular basis large xls sheets into our application.
>So first we import them so they can map the Xls fields to the destination Dbf fields in our application
>
>Xlsx in not feasable, the resulting XML's do not contain the columnnames and the domparser is way too slow to import lage xml's in Foxpro.
>
--sb--