>Is it by any chance in Excel 2007 format?
I don't know. Is there any way to examine the file to find out? Either some property I can find out in Excel or via looking at some specific bytes in the file.?

>If yes, then this problem was already discussed here and IMPORT function is not going to work.

Ouch.

Thanks a bunch for responding.




>
>>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