VFP supports direct import from Excel files up to Excel 2003. However, the files saved in Excel 2007 as 2003 format are not recognized. You either have to re-save a spreadshhet in a format VFP can recognize or use other means to import data. Check
Re: Excel 2007 Message #
1413574>Am trying to "Append From" an Excel file and getting the following error message:
>
>"Microsoft Excel file format is invalid."
>
>I can open the file OK in Excel, but Append from (lcFilename) XLS fails ... it looks like it is saved in a different format of worksheet than the files I had been receiving (I import this file every week)
>
>Any suggestions?
>
>Thanks
--sb--