Information générale
Catégorie:
COM/DCOM et OLE Automation
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement