Microsoft KB Archive/162073

= FIX: Import Wizard Does Not Import Spreadsheet Cells as Null =

Article ID: 162073

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0b for Macintosh
 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition

-



This article was previously published under Q162073



SYMPTOMS
When importing an Excel 5.0 for Macintosh spreadsheet or an Excel 7.0 for Windows 95 spreadsheet containing blank cells with the Import Wizard, the resulting fields in the new table contain zeros. This behavior occurs regardless of the value of the SET NULL command.



RESOLUTION
Issue a SET NULL ON command and use the IMPORT command. You can also use the APPEND FROM ... Type XL5 command after creating a table that supports null numeric values.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 5.0 for Windows.



Steps to Reproduce Behavior
 Create a spreadsheet that contains some blank cells. Make sure the cells are numeric. Save the spreadsheet into the Visual FoxPro folder and close Excel. Type the following command in the Command window:

SET NULL ON

 Start the Import Wizard, change the file type to Excel 5.0, and continue with the import process. In step three, notice the blank cells now appear as fields containing zeros. Click Finish. After the Import Wizard closes, open the new table and browse it. The fields that should be blank contain zeros.</li> Close the table and delete the file.</li> Type the following command in the Command window:

SET NULL ON

</li> Select Import from the File menu. Import the file as type Excel 5.0.</li> Type the following command in the Command window:

BROWSE

Notice the fields in the table contain null values where appropriate.</li></ol>

Keywords: kbbug kbfix KB162073

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.