PRB: OLE Error When Appending from Excel 97 Workbook
Article ID: 177339
Article Last Modified on 5/12/2003
APPLIES TO
- Microsoft Visual FoxPro 3.0b Standard Edition, when used with:
- Microsoft Visual FoxPro 5.0 Standard Edition, when used with:
- Microsoft Visual FoxPro 5.0a, when used with:
This article was previously published under Q177339
SYMPTOMS
When you use the APPEND FROM <filename> TYPE XL5 to import an Excel 97
workbook into a FoxPro table, one of two OLE error messages appear:
Visual FoxPro versions 3.0x and 5.0x running on Windows 95 produces the
following error:
OLE error code
0X800300002:%1
could not be found
Running on Windows NT 4.0 produces the following error:
OLE error code
0X800300002:
unknown OLE status code
CAUSE
The APPEND FROM command in Visual FoxPro versions 3.0x and 5.0x does not
support Excel 97 workbook files.
RESOLUTION
Here are two resolutions:
- Save the Excel workbook in Excel as a Microsoft Excel 5.0/95 workbook
and use the APPEND FROM command with the TYPE XL5 clause.
-or-
- Save the file as a Microsoft Excel 4.0, 3.0 or 2.1 worksheet and use the
TYPE XLS clause.
STATUS
This behavior is by design.
Additional query words: Excel APPEND FROM OLE
Keywords: kbinterop kbprb KB177339