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

Link Data to Excel update MP resets or can't place address

This is a discussion on Link Data to Excel update MP resets or can't place address within the MapPoint Desktop Discussion forums, part of the Map Forums category; Created a Hospital address dataset in excel. Column A is numbered 1-??? So it has a unique identifier. Link MP ...

  1. #1
    GEB
    GEB is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    2

    Link Data to Excel update MP resets or can't place address

    Created a Hospital address dataset in excel. Column A is numbered 1-??? So it has a unique identifier. Link MP to excel. Several address not found. Manual matched record to area of map then moved record to correct address. PROBLEM > when updating Link to new data entered into excel MP wants to remap those records I manually placed. What do I need to do to fix this as it takes a long time fix over and over again.???

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    With programming this is easy done, but with the mappoint.exe I dont know. Can you not export the dataset again ?

  3. #3
    GEB
    GEB is offline Junior Member White Belt
    Join Date
    Sep 2005
    Posts
    2

    Yes data can be linked again and it is done often but!!!!

    I work from a spreadsheet daily so the info changes all the time except for the address & Zip of the account. When I update the link to the data (excel spreadsheet) Mappoint will sometimes not map address that I have all ready manually mapped and or mapped and moved to the correct location. The problem is manually remapping those address again and again. Is there a fix or work around for this or is it built into Mappoint?

    I am not a programmer, just a sales rep for a medical instrumentation company and want something simple to show accounts via Icon. Clicking on the Icon brings up all the info in the spreadsheet for that account. It works great, but info changes so updating the link is necessary. Having to manually remap accounts is not hard but its time consuming.

    IS programming an option that will work with my application? If so, what kind of programming. Pleases elaborate.

  4. #4
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    Sure programming is an option with your application. Mappoint is accesable from most (if not all) programming languages. And in Excel you have the option to use VBA. For example you can make a form in VBA, put a mappoint component on it, and then the map is visible in Excel itself including programming. I cannot advice you in VBA but others can if you wants more information.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Random Link update failed error when doing UpdateLink method
    By stephenmillington in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 11-01-2005, 03:49 AM
  2. MP2004 Link Update Failed -2147190772
    By AndyWood in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-13-2005, 05:06 PM
  3. How can I link Mappoint with Excel?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-27-2004, 06:17 AM
  4. How do I, or can I update address information in M....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-12-2002, 11:41 AM
  5. Is it possible to update the Address Data (Postal ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-25-2002, 06:11 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 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127