Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPENDING FROM XLS generates error
Message
From
29/03/2000 17:38:37
 
 
To
29/03/2000 17:26:59
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00352440
Message ID:
00352448
Views:
11
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 ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform