MapForums
Community of VE/MapPoint Users and Developers
Importing Zip Codes from Excel to MapPoint
This is a discussion on Importing Zip Codes from Excel to MapPoint within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, I'm trying to import an excel document into MapPoint. I'm very new to this software, so i have no ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-01-2006
| |||
| |||
| Importing Zip Codes from Excel to MapPoint I'm trying to import an excel document into MapPoint. I'm very new to this software, so i have no clue how to make this work. I made an excel document with 2000 names of pumping units, and titled it "name" and then by each unit there is a zip code...which i titled "zip code"....How do i get this to import right? I won't import more than 8 at a time and then i don't know what it does with the rest. It's really becomeing a pain in the neck. I have 2 more weeks to get this prepared for our sales meeting.....PLEASE HELP!         |
|
02-02-2006
| |||
| |||
|
Hi, This might help. Is it possible that you clicked on the Link Data Wizard instead of the Import Data Wizard. The link wizard requires you to have a Primary Key (i.e. a unique reference) for each record, for example an account number. If no column designated as a primary key MapPoint will use your zip code. If there any double ups you will get the message that only 8 unique records have been mapped in this set. The import wizard should sort the problem. Hope this helps Regards Stephen Kilbee www.cover-point.co.uk |
|
02-05-2006
| |||
| |||
|
Hi Jen If you are only able to map 8 at a time it sounds like you are trying to map them as either shaded or sized circles. If all of the zip codes are different (I take it the 200 locations all refer to different places) then you have to map them as PushPins. Select the file you want to import and after the import has completed a "Map Type" dialog comes up. Select "Pushpin" (at the bottom) and in the next screen give it an appropriate symbol. This will then map all 200 in one go. Hope this helps I.T. |
 |
| ||||
| Posted By | For | Type | Date | |
| AXS Visitor Tracking System - Administrator's Page | This thread | Refback | 12-18-2007 09:29 AM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Export Zip Codes To Excel | JimS | MapPoint 2006/2009 Discussion | 4 | 01-24-2006 01:46 PM |
| Importing multiple maps into Excel | dadburne | MapPoint 2006/2009 Discussion | 5 | 10-19-2005 12:07 PM |
| Export Zip Codes to Excel Problem | Anonymous | MapPoint 2006/2009 Discussion | 0 | 11-09-2004 04:24 PM |
| importing data from excel to mappoint | Layne | MapPoint 2006/2009 Discussion | 0 | 05-09-2003 12:40 PM |
| importing excel file into mappoint | misterb83 | MapPoint 2006/2009 Discussion | 2 | 04-14-2003 01:56 AM |
All times are GMT -5. The time now is 01:42 AM.
