>Maybe is file from excel 2007 in OpenXML format. VFP and ODBC driver this format don't know.
It doesn't *seem* to be, but I'm not sure. Is there any way to know? Is it possible it's something else? Have you (or anyone else) been able to APPEND FROM Excel 2000 spreadsheets? I've tried TYPE XLS, XL5 and XL8 -- to no avail.
Thanks in advance.
-- John
>
>MartinaJ
>
>>Merry Christmas, Happy Holidays to all...
>>
>>Anybody know why I cannot do an APPEND FROM Excel any more?
>>
>>It's an Excel 2000 spreadsheet and no matter what I try (APPEND FROM, IMPORT FROM, even a SQLCONNECT("Excel Files")) gives me an error. I get "Microsoft Excel file format is invalid" from IMPORT/APPEND, and the ODBC error says "External table is not in expected format".
>>
>>Is this the beginnings of VFP's obsolescence?
>>
>>Thanks in advance to all those toiling away today...
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".