Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import/Append/SQLConnect from Excel failing
Message
De
25/12/2007 14:15:09
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01277439
Message ID:
01277441
Vues:
15
>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".
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform