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

Export "Places" from MapPoint 2010 to Access

This is a discussion on Export "Places" from MapPoint 2010 to Access within the MapForums Plus Downloads forums, part of the MapForums Plus category; I wrote this Access script/module to grab the Places (restaurants, train stations, etc.) from MapPoint 2010. It's mostly based on ...

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

    Export "Places" from MapPoint 2010 to Access

    I wrote this Access script/module to grab the Places (restaurants, train stations, etc.) from MapPoint 2010. It's mostly based on this article by John Washenberger from 8 years ago..
    Extracting the Mappoint 2002 Points of Interest

    It's not perfectly user friendly, and it leaks memory and must be restarted a few times, but it works. I found 1,604,176 places in the North / Western Hemisphere. Between Longitude -180 and 0 and Latitude between 0 and 180.

    To run, first open MapPoint 2010. Go to View | Show/Hide Places and turn on/off the Places for the categories you want.

    Now in the Access database attached, go to Module1. Click Run Sub/UserForm and select ExportPOIs. It will run for a day or so, but MapPoint will eventually crash, I think because of a memory leak. Close MapPoint and re-open it. Note which was the last Latitude row it was working on and in the code, change the For...Next loop for the Latitude to start at your current Latitude. It will probably run for another day or two and crash again. Repeat.

    (To get rid of the memory leak issue, you should probably instantiate MapPoint from within the program instead of attaching to it. And reinstantiate it each time it goes to the next Latitude.)

    Have fun and let me know if you have any questions or suggestions!

    Eric
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Eric Frost; 09-30-2009 at 10:43 AM. Reason: fixed Category
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    houstonian is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    3

    Re: Export "Places" from MapPoint 2010 to Access

    Hi Eric,

    It seems working, is it too difficult to have the sub run for the USA only, or can I specify a state or city..

    Thanks,

    Albert
    Last edited by houstonian; 01-28-2010 at 10:53 AM. Reason: n

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

    Re: Export "Places" from MapPoint 2010 to Access

    Right now it's set to loop over the entire northern hemisphere.

    See the For loops with the lat/lon coordinates. You could determine the range of lat/lons you need to cover your area and then modify the values in the for loops. For a city it might be just a single lat/lon since it does a 50 mile radius.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  4. #4
    houstonian is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    3

    Re: Export "Places" from MapPoint 2010 to Access

    So far so good, now I am strugling to include the Telephone number, I tried to mimic other fields but the sub is not working.. I hope you can help me with this one too.

    Thanks,

    Albert

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

    Re: Export "Places" from MapPoint 2010 to Access

    I could never get the telephone number to come out :-/

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  6. #6
    houstonian is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    3

    Re: Export "Places" from MapPoint 2010 to Access

    Thanks

  7. #7
    Elgrande is offline Junior Member White Belt
    Join Date
    Oct 2009
    Location
    The Netherlands
    Posts
    6

    Re: Export "Places" from MapPoint 2010 to Access

    Hi there,

    i am trying to use this but get a error message 3346 telling me that the selected fields/values are diferent from the one in te table.

    I am ussing the european version of mappoint.

    hopy you could help me on this

    sql = "INSERT INTO POIs ( Name, Lat, Long, Category, Address, Street, City, Region, Country, PostalCode, iLat, iLong, TimeStamp ) SELECT "
    sql = sql & Chr$(34) & strName & Chr$(34) & " AS Expr1, " & CStr(dblLat) & " AS Expr2, "
    sql = sql & CStr(dblLong) & " AS Expr3, " & Chr$(34) & strCategory & Chr$(34) & " AS Expr4, "
    sql = sql & Chr$(34) & strAddress & Chr$(34) & " AS Expr5, " & Chr$(34) & strStreet & Chr$(34) & " AS Expr6, "
    sql = sql & Chr$(34) & strCity & Chr$(34) & " AS Expr7, " & Chr$(34) & strRegion & Chr$(34) & " AS Expr8, "
    sql = sql & Chr$(34) & strCountry & Chr$(34) & " AS Expr9, " & Chr$(34) & strPostalCode & Chr$(34) & " AS Expr10, "
    sql = sql & CStr(iLat) & " AS Expr11, " & CStr(iLong) & " AS Expr12, " & Chr$(34) & CStr(Now()) & Chr$(34) & " As Expr13;"

    This is the VBA what the debuger is selecting

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

    Re: Export "Places" from MapPoint 2010 to Access

    This sounds familiar. Check the field types and table definition. Something is not right.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting the "show or hide places"
    By jhoffend in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 09-20-2007, 12:43 PM
  2. Add a Category to "Show or Hide Places"
    By ArtS in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 04-18-2007, 04:13 PM
  3. How can I open "Show or Hide places" in program
    By Chester in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-26-2004, 08:12 PM
  4. Export "Find nearby places" along a route?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 11-06-2003, 09:56 AM
  5. "Nearby Places" accuracy
    By Val Skinner in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-05-2003, 10:21 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