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

Import locations

This is a discussion on Import locations within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have 300 locations to map in Canada. I tried to import an Excel file with the name, the address ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Import locations

    I have 300 locations to map in Canada. I tried to import an Excel file with the name, the address (ex: 453 King Street), the city and the province. I can't get Mappoint to recognize my address, so everytime it map the locations by the city. Is there a way to make this work, if not I will have to add the location one by one with the find option.

    Thanks

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    Could you post a sample (a row or two) of your excel file?

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Name____Address____________City___________Province ______Country
    9891318__500 Papineau_______Montreal_______Quebec________Canada
    9894213__180 Tremblay_______Boucherville____Quebec________Canad a

    I found out that if I choose USA for the country the matching option is set to street address but if it's CANADA the matching option is city. So i guess that I dont live in the right country to do what I want to do.

    If someone knows a way to bypass this problem let me know.


    Thanks

  4. #4
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    I changed the country to United States (Which, as you pointed out gives you the "Data Type" Address 1 Column)

    Then I selected Data Type City for the Province Column, clicked Finish and it imported just fine.

    Give it another try, should work!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. finding locations
    By SimonPearse in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-23-2004, 08:56 AM
  2. Problem with locations
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 09-12-2004, 09:34 AM
  3. Incorrect locations?
    By harris00 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-25-2004, 10:40 PM
  4. duplicate locations in one city
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-28-2003, 10:05 AM
  5. array of locations
    By Bart Vervenne in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-14-2003, 04:03 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