Import addresses to a map
On the Data menu, click Import Data Wizard.
- or -
On the Standard toolbar, click Import Data Wizard
.jpg "Gg650038.ALLIDWButton(en-us,MSDN.10).jpg")
.Select the source file you want to import, and then click Open.
Note You must select the type of file you want to import from the Files of type drop-down list. Only files of that type are displayed in the selection list.
Choose the sheet, range, folder, table, query, view, or separator character.
Depending on the data source, you may have to choose specific data or choose a separator character. This and the next step will be skipped in the Import Data Wizard if your data source does not require further disambiguation of data.
If you are importing data from Excel, Access, or Outlook, or if you are using Microsoft Data Link, you may have to choose specific data.
If you are importing from a plain-text file (*.txt, *.csv, *.asc, or *.tab format), you must choose the separator character.
After selecting the data, click Next. If you did not have to choose a sheet, range, table, or separator character, this step is skipped.
Select the data type for each column of data, select the Country/Region that pertains to the data, and specify if the first row of your data contains column headings.
Notes
After selecting which columns to include and the data type for each column, check the informational text box at the bottom of this wizard page. It will list the geographical unit each record will be matched to and the Country/Region of the data.
If you are mapping locations from more than one country, make sure that you select <Multi/Other> in the Country/Region list.
Select the properties for the Pushpin set.
Click Finish.
The Import Data Wizard will attempt to match the records of the data to the specified location. If it cannot match one or more records to a place on the map, you must match unmatched records.