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.