Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
APPENDING FROM XLS generates error
Message
De
29/03/2000 17:38:37
 
 
À
29/03/2000 17:26:59
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00352440
Message ID:
00352448
Vues:
12
Since the VFP 5.0 Import only supports up through Excel v5.0, this may be
due to a uniqueness of the Excel 97 format. First you may want to try:
import from test.xls type XL5
it may handle the difference, where XLS, according to the help file only
supports "versions 2.0, 3.0, and 4.0". [See the Help file]
Another alternative may be to save the speadsheet in a format older than 97
(v8.0) or 2000 (v9.0).

>Hey, O wise ones!
>
>I've taken over a FPW program from someone who was APPENDing in an Excel Spreadsheet (XLS) into a Fox table. It's been brought forward to VFP 5 (using SBT -- gotta stay with 5), but the following APPEND statement gives me an error:
>
>APPEND FROM (ALLTRIM(lc_file)) TYPE XLS
>
>The error is:
>OLE Error code 0x80030002 %1
>
>Should there be some kind of Code Page manipulatin going on here? I've never had to work with CPs, so I don't know.
>
>Thanks in advance, those with more knowledge than I ...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform