Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exception Code 000005 when appending from Excel
Message
From
02/11/2004 08:34:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Exception Code 000005 when appending from Excel
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00956973
Message ID:
00956973
Views:
43
I have an application that imports data from an Excel workbook into a Visual FoxPro 6 table using the command:
APPEND FROM &impfile  TYPE XL8 SHEET checks
There can be up to five worksheets in the workbook.

The import works fine as long as Excel 2002 or earlier is installed on the computer running the application. However, if Excel 2003 is installed, I get Exception Code 000005 at the above line of code. I can open Excel, delete the last two pages and the worksheet can be imported without error.

Any idea why extra sheets at the end of the workbook would cause an error when appending the first sheet? Any suggestions as to what I need to do would be greatly appreciated.

Thanks in advance.
Reply
Map
View

Click here to load this message in the networking platform