PRB:Structure Appears Changed If Excel 5.0 Saves in DB4 Format

ID: Q122969

The information in this article applies to:

Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, 2.6, 2.6a

SYMPTOMS

When you try to import or open a database generated and saved as DB4 format in Microsoft Excel version 5.0 into FoxPro for Windows, you may get fewer fields than were in the original spreadsheet. This usually happens if the spreadsheet size was changed by adding more fields to its original number of fields.

CAUSE

When you save a spreadsheet for the first time in Excel version 5.0, the export range is saved with it. Updating the number of fields doesn't update the export range automatically.

RESOLUTION

When saving the spreadsheet as DB4 format, update the export range so that the correct number of fields will show up in FoxPro. To do so:

1. Click Insert in Excel.

2. Chose Name.

3. Select Define.

4. In the Define Name dialog box, type database.

5. In the Define Name dialog box Under the Refers to: option, update the

   range to include all the added fields

6. Save the sheet as a DB4 format. Now, all the fields will show up in

   FoxPro.

Additional reference words: FoxWin 2.50 2.50a 2.50b 2.60 2.60a KBCategory: kbinterop kbprb KBSubcategory: FxinteropSpread

Last Reviewed: June 26, 1995