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

Post codes with lat.-lon.-Data in Access

This is a discussion on Post codes with lat.-lon.-Data in Access within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello, as I'm totally new with MapPoint, I got a serious problem. I got a table (postcodes of Germany) in ...

  1. #1
    markus_figge is offline Junior Member White Belt
    Join Date
    Nov 2006
    Posts
    3

    Post codes with lat.-lon.-Data in Access

    Hello,

    as I'm totally new with MapPoint, I got a serious problem. I got a table (postcodes of Germany) in Access. I need to add two fields with latitude and longitude for each postcode, as I have to calculate the distance from various places. The calculating routine works just perfect, but the data for my postcode table is simply too large. Does anyone know, how I can do that (not manually each by each) with code? I got MapPoint 2004 and Access 2000.

    Thank you very much in advance

    Markus Figge

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Post codes with lat.-lon.-Data in Access

    Using lat/lon can you just do a straight line distance calculation between the post codes or do you need the road/Route distance from MapPoint?

    If you have a list of all the postcodes, you should be able to do a Find on each one and place a Pushpin.. either through code you could extract the lat/lon's or using something like to Pushpin Tool to export to Excel.

    Eric

  3. #3
    markus_figge is offline Junior Member White Belt
    Join Date
    Nov 2006
    Posts
    3

    Re: Post codes with lat.-lon.-Data in Access

    Dear Eric,

    thank you for your quick answer. Yes, I intend to just calculate straight lines from a to b. I do have the list of all postcodes already(sometimes 1 postcode,5 different little villages or towns) could you tell me how to use my list, better ... how to pushpin each of them and get the latitude and longitude for each pushpin? (best would be code !! )

    Thank you

    Markus

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using Geographic Codes to Import Data into MapPoint 2004
    By Anonymous in forum MP2K Magazine Articles
    Replies: 1
    Last Post: 09-22-2004, 06:43 AM
  2. BA post codes UK
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-30-2004, 01:12 PM
  3. UK District Post codes
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-24-2003, 11:23 PM
  4. I would like to post data to each state in the US.....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-31-2002, 02:02 PM
  5. I am plotting data by zip codes for Seminole Count....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-09-2002, 07:20 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 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