FIX: Imported MS Excel Spreadsheet Missing Beyond Z Column

ID: Q98433

2.50 WINDOWS kbprg kbfixlist kbbuglist

The information in this article applies to:

SYMPTOMS

When you import a Microsoft Excel 3.0 or 4.0 spreadsheet into FoxPro 2.5 for Windows by issuing the IMPORT FROM <path>\EXCEL\...\<file>.XLS TYPE XLS command from the Command window, if the spreadsheet contains columns beyond the Z column, for example, AA, AB, and AC, those columns are missing when you browse the spreadsheet in FoxPro 2.5 for Windows.

RESOLUTION

To work around this problem, do the following:

1. Open the .XLS file in Microsoft Excel.

2. Select (highlight) the first cell (A1), and then select all the

   cells by pressing SHIFT+CTRL and the RIGHT ARROW and DOWN ARROW
   keys.

3. From the Data menu, choose Set Database.

4. From the File menu, choose Save As. In the Save File As Type box,

   select DBF 3.

5. In the Command window in FoxPro 2.5 for Windows, issue the command:

      USE file.DBF
      BROWSE

All the cells from the spreadsheet will be available in the Browse window.

STATUS

Microsoft has confirmed this to be a problem in FoxPro 2.5 for Windows. This problem was corrected in FoxPro 2.5a for Windows.

REFERENCES

"Language Reference," version 2.5, IMPORT command, page L3-569

Additional reference words: FoxWin 2.50 truncated missing cut off disappear removed buglist2.50 fixlist2.50a KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: FxinteropSpread Solution Type : kbfix

Last Reviewed: September 22, 1997