Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import/Append/SQLConnect from Excel failing
Message
From
25/12/2007 14:15:09
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01277439
Message ID:
01277441
Views:
14
>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".
Previous
Reply
Map
View

Click here to load this message in the networking platform