Microsoft KB Archive/124586

{| = BUG: IMPORT or APPEND FROM Empty Spreadsheet Gives Error =
 * width="100%"|

ID: Q124586

The information in this article applies to:


 * Microsoft FoxPro for Windows, version 2.6a

SYMPTOMS
Importing or appending an empty Spreadsheet (no data in it) into FoxPro, results in the "File Read Error" error massage.

RESOLUTION
Use an ON ERROR Routine to trap the error.

Sample Code
ON ERROR DO MyError && Calls the Procedure MyError for any error IMPORT FROM  TYPE XLS ON ERROR &&Sets FoxPro back to its default Error Handler PROCEDURE MyError

IF ERROR = 1104 ** Error: File Read Error WAIT WINDOW "The Spreadsheet is Empty" ENDIF RETURN

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Steps to Reproduce Problem
1. In Excel, save a Spreadsheet with no data in it as an Excel version 4.0

Worksheet 2. In FoxPro, enter this Command: IMPORT FROM  TYPE XLS Additional reference words: FoxWin 2.60a buglist2.60a KBCategory: kbinterop kbcode kbbuglist KBSubcategory: FxotherGeneral
 * }