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 4 of 4

Zip code-list in excel and pins in MapPoint/msn maps

This is a discussion on Zip code-list in excel and pins in MapPoint/msn maps within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello everyone! Perhaps you can answer my question: Is it possible to view pins at the location of every zip ...

  1. #1
    michi2000 is offline Junior Member White Belt
    Join Date
    Dec 2006
    Posts
    2

    Zip code-list in excel and pins in MapPoint/msn maps

    Hello everyone!

    Perhaps you can answer my question:
    Is it possible to view pins at the location of every zip code, which are listed in an excel-sheet?
    The excel-sheet contains the following zip codes, for example:
    User zip code
    Mr Smith 20024
    Mrs Meyer 20024
    Mr Archer 10003
    etc.

    And for every user should appear a pin on a map (MapPoint oder msn maps) after an import of this list.
    Or does anybody know another possibilty to realize such a project?

    Kind regards,
    Michael Holthausen

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Zip code-list in excel and pins in MapPoint/msn maps

    Hi,

    Yes a zip code is inough to put a pushpin. I think you are referring to the standalone mappoint application (not programatically) right ? I cannot tell you how to import I'm pretty sure it is possible.

  3. #3
    michi2000 is offline Junior Member White Belt
    Join Date
    Dec 2006
    Posts
    2

    Re: Zip code-list in excel and pins in MapPoint/msn maps

    Hi!

    Thanks for your answer.
    Yes, my question refers to MapPoint 2006.
    We're searching an application to show a pin for all our customers in a map. For every customer should appear a pin in this map, so we can see the accumulation of customers e.g. in one city.
    The data of our customers are stored in a MySQL-Database. So an export of zip codes into an excel-sheet shouldn't be the problem.

  4. #4
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Zip code-list in excel and pins in MapPoint/msn maps

    If you use Import Data Wizard then all the records can be displayed as pushpins. However for your application the problem is that all the customers with the same zip will be plotted on top of one another. So you may have 50 customers in 20024 but looking at the map there will be just one pushpin visible. If you click on the pushpin then there will be a list of the 50 customers so this map is perfectly OK for analysis (eg. how many customers in Hamburg) just not much help visually. What I did was to produce a second map based on having obtained the subtotals in Excel by Zip and then plotting the map with symbols that showed the number of customers eg. circles where the area of the circle is proportional to the number of customers. If youd like to see an example then send me a private message with your e-mail and Ill send one through.

    Hope this helps

    David

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Updating Maps in Excel without Mappoint
    By Cuda in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 02-06-2006, 10:16 PM
  2. Send zip code & distance, receive list of zips back?
    By morfy50 in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 08-02-2005, 08:34 AM
  3. How do I extract city list to excel?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-15-2005, 11:02 AM
  4. exporting list of english counties to excel
    By roberta walker in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-20-2004, 10:42 AM
  5. After you geocode a list of items from an excel fi....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-29-2000, 08:00 PM

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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96