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

MS Access import and export

This is a discussion on MS Access import and export within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have an access application used to schedule employees work routes. I need to determine the distance being travelled between ...

  1. #1
    Steve_pom is offline Junior Member White Belt
    Join Date
    Mar 2008
    Posts
    1

    MS Access import and export

    I have an access application used to schedule employees work routes. I need to determine the distance being travelled between work locations and then bring this figure back into access.

    Is this a possibility: importing a list of postcodes to mappoint and exporting a sum distance back into access?

    thanks for any and all advice

  2. #2
    lfdmike's Avatar
    lfdmike is offline Member Green Belt
    Join Date
    May 2004
    Posts
    56
    Blog Entries
    7

    Re: MS Access import and export

    That may take some programming- not my area of expertise with MP or VE

    In stand alone mode, you can import those locations from Access. You can create a route and optimize between those locations. The guide will have a breakdown of distances each leg of the route. Just need to get that back to Acccess somehow

  3. #3
    tfmiltz is offline Member Green Belt
    Join Date
    Feb 2005
    Posts
    52

    Re: MS Access import and export

    you could go centroid on the zip polygon - then differentiate as two points on a sphere using lat/lon (formula is in many posts on this forum).

    Would be better to geocode the start and destination address then work with those lat/lon's.

    Tim Miltz

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Import / export routing for sales orders
    By marym in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-29-2004, 02:46 PM
  2. Access import
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-17-2003, 09:33 AM
  3. Import stops in Access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-19-2003, 02:05 PM
  4. Import Data From Access
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-05-2003, 08:24 AM
  5. [b]How do I export data into an ACCESS (mdb) file using VB6?
    By rmozes in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-05-2003, 08:17 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