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

Grab ALL the data from Mappoint 2004 datasets

This is a discussion on Grab ALL the data from Mappoint 2004 datasets within the MapPoint Desktop Discussion forums, part of the Map Forums category; I need to grab the data from Mappoint 2004 datasets expecially the city name, address and lat/long coordinates associated to ...

  1. #1
    princedoe is offline Junior Member White Belt
    Join Date
    Jun 2006
    Posts
    3

    Grab ALL the data from Mappoint 2004 datasets

    I need to grab the data from Mappoint 2004 datasets expecially the city name, address and lat/long coordinates associated to addresses. How can I do it ? I need to handle these data with access. Is there a way to export to a csv file or an add-on for Mappoint ? Help Thank
    Mo

  2. #2
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    Hi,

    I need to grab the data from Mappoint 2004 datasets
    I think your talking about your own DATA imported to Mappoint.

    1- Directly from Mappoint, you have to draw a shaded area and export it to excel. In Access you import again your Excel data.
    You can't calculate directly Latitude and Longitude of your addresses.

    2. But, You can do that programatically
    If you want to do that Just give us more details about your needs...

    Ciao

  3. #3
    princedoe is offline Junior Member White Belt
    Join Date
    Jun 2006
    Posts
    3
    Nope I'm talking about the data isnide the \data folder. There already are all the routes, with addresses in the Mappoint without importing your own data. If for example you zoom on the map to the max details, you can see the addresses on the map wight clicking with the mouse. Therefore Mappoint already have ALL the addresses with the association to the lat/long coordinates. I need to grab these information (address, number, coordinates) to an external file. This is useful for me to find the right coordinates for any addresses. Mappoint has all this inside the data files, how can I grab, capture, see, handle them ??

  4. #4
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    So, just open that Access EuroDemo.mdb ou UsaDemo.mdb file. I can't give the password, but making a good search in this forum you can find by yourself

  5. #5
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    Hah...

    In that database you have only the Demographics data!

    You can't grab all data existing in Mappoint about all the addresses.
    In a small zone you can do that programatically.

    Do a search here about methods for obtaining lat/lon ( calcpos, and so on ).

    I did a program like that to check if I have all the streets existing in Paris, and I remember that my computer was working all the night for that.

  6. #6
    princedoe is offline Junior Member White Belt
    Join Date
    Jun 2006
    Posts
    3
    Thanks but I still need some help. Let say it easier:

    I have an Acess mdb database which contains the name, address, postcode and cities of my customers. I want to extract for them the lat/long coordinates. So how can I communicate to MP from Access ? I have thousands of customers and the corrodinates are useful to map them in Google Earth too. Not that easy uh ?

  7. #7
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Import your data into MapPoint using MapPoint's Data Import Wizard.

    Then use John Meyer's Pushpin Tool to find the coordinates. This will give you them in Excel.

    Alternatively write a little program to do it. You will need to use VBA or VB6 (or any COM-aware language), and this approach could write directly into the Access database.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  8. #8
    AUR
    AUR is offline Junior Member White Belt
    Join Date
    Dec 2006
    Posts
    11

    Re: Grab ALL the data from Mappoint 2004 datasets

    Hi Princedoe

    Did u manage to find the sol of your problem, i'm stuck with the same situation as yours.

    I need to export all addresses+lat/lon into an external file so that later i can import in access and communicate with Map point.

    Please can you help me ,

    regards
    AUR

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Importing data into MapPoint 2004
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 12-07-2004, 10:59 AM
  2. Newbie- Converting Mappoint 2004 data to Map Info data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 06-10-2004, 02:11 PM
  3. Missing Street Number Data in MapPoint 2004
    By scundy in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-04-2003, 12:02 PM
  4. Data Importer now available for MapPoint 2004
    By Anonymous in forum News and Announcements
    Replies: 0
    Last Post: 09-22-2003, 11:25 AM
  5. Mapping data in MapPoint 2004
    By cableghost in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-16-2003, 08:50 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