MapPoint 2000: Data Import Wizard Incorrectly Assigns ZIP Heading to Column (231512)
The information in this article applies to:
This article was previously published under Q231512 SYMPTOMS
The Data Import wizard in Microsoft MapPoint 2000 may incorrectly assign
the ZIP heading to a column that does not contain zip codes.
CAUSE
This behavior can occur if either of the following conditions are true:
- The imported data includes only one column of all five-digit
numbers, and this column does not contain zip codes.
- The imported data includes more than one column of all five-digit
numbers, and the first such column does not contain zip codes.
NOTE: MapPoint 2000 automatically assigns the ZIP heading to the
first column of data that contains all five-digit numbers.
RESOLUTION
To work around this issue, manually change the column heading in the Data
Import wizard. To do this:
- On the File menu, click Import Data.
- Click to select the document you want, and then
click Open.
NOTE: If the document you want to open is a Microsoft Excel
workbook, click the worksheet containing the data you want to import,
and then click Next. - Click a pre-defined heading in the heading box, or type the
heading you want in the heading box.
- Click Finish.
STATUSMicrosoft has confirmed that this is a problem in Microsoft MapPoint 2000.
Modification Type: | Major | Last Reviewed: | 9/14/2001 |
---|
Keywords: | kbbug kbui KB231512 |
---|
|