Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Importing Zip Codes from Excel to MapPoint

This is a discussion on Importing Zip Codes from Excel to MapPoint within the MapPoint Desktop 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 ...

  1. #1
    Jennl881 is offline Junior Member White Belt
    Join Date
    Feb 2006
    Posts
    1

    Importing Zip Codes from Excel to MapPoint

    Hi,
    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!

  2. #2
    stephen kilbee's Avatar
    stephen kilbee is offline Junior Member Yellow Belt
    Join Date
    Nov 2002
    Posts
    18
    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

  3. #3
    I.T. is offline Junior Member White Belt
    Join Date
    Mar 2005
    Posts
    9
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Export Zip Codes To Excel
    By JimS in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 01-24-2006, 02:46 PM
  2. Importing multiple maps into Excel
    By dadburne in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 10-19-2005, 01:07 PM
  3. Export Zip Codes to Excel Problem
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-09-2004, 05:24 PM
  4. importing data from excel to mappoint
    By Layne in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-09-2003, 01:40 PM
  5. importing excel file into mappoint
    By misterb83 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-14-2003, 02:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36