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