General information
Category:
COM/DCOM and 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 ...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only