Microsoft KB Archive/98433

{| = FIX: Imported MS Excel Spreadsheet Missing Beyond Z Column =
 * width="100%"|

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 \EXCEL\...\ .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.