Is it by any chance in Excel 2007 format? If yes, then this problem was already discussed here and IMPORT function is not going to work.

>We have been receiving a spreadsheet from a customer and importing it into a DBF.

>lcImportFile = GETFILE()
>IMPORT FROM (lcImportFile) TYPE XLS

>This has been working for quite some time. Now we are getting the "Invalid File Format" error on what appears to be an identically configured spreadsheet.
>
>I can open the spreadsheet in my copy of Excel. Saving it back to another filename does not clear the problem. Saving it back to a different format (Excel 5 or Excel 97/2003/5) does not clear the problem.
>
>I can cut and paste all the data into a new spreadsheet. That works well enough (some differences in column widths but all the data is there) but it is not something I want to introduce in code -- probably break something else.
>
>We get similar spreadsheets from other
>Opening the spreadsheet and saving it as a DBF would require some extensive processing to get the field names and widths correct.
>
>I have asked the user to check with the customer to see if they have made any changes to their Excel configurations.
>
>I'm looking for some advice here on how I can look at the spreadsheet and determine what is making the format invalid.
>
>Thanks to all