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

Why don't all the addresses get pinned from excel?

This is a discussion on Why don't all the addresses get pinned from excel? within the General Chat forums, part of the Map Forums category; I just got MapPoint last week and have not been able to import all the addresses from an excel sheet ...

  1. #1
    MCUTS is offline Junior Member White Belt
    Join Date
    Mar 2012
    Posts
    4

    Why don't all the addresses get pinned from excel?

    I just got MapPoint last week and have not been able to import all the addresses from an excel sheet that I have.

    There are about 1500 names and addresses on the excel sheet but when I import them the program typically cannot find close to 1,000 of them. I dont think it's the format of the excel sheet, because then it would not take the other 500. Is it just a case of MapPoints data base of streets and addresses being to small or am I doing something wrong?

    I'm in Memphis not a rural town, so I feel like the roads and addresses should be apart of their data base.

    Thanks for your help

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

    Re: Why don't all the addresses get pinned from excel?

    Yeah, that's a really low match rate. Normally you'd expect at least 80%+.

    Are you using the latest version MapPoint 2011?

    In any case, I would expect a much higher match rate even with the older versions, unless for some reason you are dealing primarily with new neighborhoods.

    Can you post a sample (say 10 or 50 records) of the addresses that don't match?

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

  3. #3
    MCUTS is offline Junior Member White Belt
    Join Date
    Mar 2012
    Posts
    4

    Re: Why don't all the addresses get pinned from excel?

    Its not letting me attach an excel file, so here are the address.. let me know if there's a better way to do it.


    Primary Address Street Primary Address City Primary Address State Primary Address Postalcode Status Lead Source Lead Source Description
    9305 Stateline Road #28D Olive Branch MS 38654 Assigned TV No
    817 West Barton Avenue West Memphis AR 72301 Assigned No
    8132 Woodson Drive Olive Branch MS 38654 Assigned Referral Friend No
    812 Sorrell Circle Marion AR 72364 Assigned Radio 95.7 No
    8061 Falcon Drive Olive Branch MS 38654 Assigned Referral johen92201@earthlink.net No
    717 E. Broadway West Memphis AR 72301 Assigned Radio 101 NO
    7143 Willow Point Drive Horn Lake MS 38632 Assigned Radio 95.7 No
    616 Rainer Road Apt3 West Memphis AR 72301 Assigned Radio 95.7 No
    607 S. Avalon Street Unit 1 West Memphis AR 72301 Assigned No
    5620 Sycamore Cove Horn Lake MS 38637 Assigned Radio 95.7 No
    547 Par Drive #12 Marion AR 72364 Assigned No
    503 Corell Avenue West Memphis AR 72301 Assigned Radio 95.7 No
    501 Piedmont St. West Memphis AR 72301 Assigned Radio 101 NO
    438 Magnolia Street Marion AR 72364 Assigned Online No
    413 Birdie Apartment #3 Marion AR 72364 Assigned Radio 95.7 No
    406 Magnolia Marion AR 72364 Assigned Radio 95.7 No
    336 Shady Grove Street Marion AR 72364 Assigned Radio 95.7 No
    313 Scott Street Blytheville AR 72315 Assigned Online No
    311 S. 19th Street West Memphis AR 72301 Assigned No
    307 Dozier Circle Marion AR 72364 Assigned Radio No
    2590 East County Road Apt. 4 Blytheville AR 72315 Assigned Radio 95.7 No
    2590 East County Road #4 Blytheville AR 72315 Assigned No
    2511 S. Woodlawn Street West Memphis AR 72301 Assigned No
    24 Alma Street Proctor AR 72376 Assigned Online No
    219 1/2 West Danner West Memphis AR 72301 Assigned Radio 101 No
    1719 Etsy Drive Clarksdale MS 38614 Assigned Radio 101 No
    1602 Scottwood West Memphis AR 72301 Assigned Radio 101 No
    125 Sycamore Marion AR 72364 Assigned Radio 95.7 NO
    121 South Crescent Drive Blytheville AR 72315 Assigned Radio 101 No
    1131 W. Moultrie Blytheville AR 72315 Assigned No
    1009 W. Walnut Blytheville AR 72315 Assigned Radio 101 No

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

    Re: Why don't all the addresses get pinned from excel?

    Zip your Excel file first, then attach.

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

  5. #5
    MCUTS is offline Junior Member White Belt
    Join Date
    Mar 2012
    Posts
    4

    Re: Why don't all the addresses get pinned from excel?

    Ok, I think that worked..

    Thanks
    Attached Files Attached Files

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

    Re: Why don't all the addresses get pinned from excel?

    Using MapPoint 2010, it matched 23 out of 32 of them.. the rest I matched to zip code. Not a great match rate, but maybe acceptable.

    I wasn't sure, but noticed I do actually have MapPoint 2011 installed on this computer as well so I went ahead and tried thinking it might do a slightly better job, instead it only matched 1 of them! leaving 31 unmatched. This is bizarre. Can someone else confirm?

    What version are you using? I assume MapPoint 2011?

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

  7. #7
    MCUTS is offline Junior Member White Belt
    Join Date
    Mar 2012
    Posts
    4

    Re: Why don't all the addresses get pinned from excel?

    Yeah I have MapPoint 2011..

    Thanks,

  8. #8
    reed is offline Junior Member White Belt
    Join Date
    Nov 2012
    Posts
    1

    Re: Why don't all the addresses get pinned from excel?

    does it really work? a little suspection.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Import Addresses from Excel using VBA
    By Sidereus in forum MapPoint Desktop Discussion
    Replies: 18
    Last Post: 11-26-2011, 10:39 AM
  2. order of the addresses in the excel export
    By pileggi in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-27-2010, 09:48 AM
  3. Import a list of addresses from Excel to create optimized route
    By bran987 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-10-2009, 08:33 PM
  4. BAd addresses
    By garon5 in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 02-16-2007, 10:32 AM
  5. MPControl embedded in excel - excel loses functionality
    By ruyasan in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-20-2004, 03:41 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