FIX: Imported MS Excel Spreadsheet Missing Beyond Z Column

 Last reviewed: September 22, 1997
Article ID: Q98433
2.50 WINDOWS kbprg kbfixlist kbbuglist

The information in this article applies to:

  • Microsoft FoxPro for Windows, version 2.5

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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.