I know there's some maps stuff around here but I don't know if importing the time values has ever been done. You could look here Map a Location in Access. You might get some useful information out of THIS post too. But I don't think either one of those is getting the data into access if that is the end goal.

Thank you for the link, I just finished watching it. I am opening google with different code, but the results are the same. Still something I need to learn to do with about 6 appointments a day.

Usually, if you can do it with Excel, then you can do it in Access, even if you have to tell Access to make Excel do it, like I just showed with the Link to Excel extended cut. This sounds like an interesting project, however. I'll add it to the TechHelp list. :)

Jon Hi Jon,  Were you ever able to figure out the drive time calculator from one appointment to the next?

I did, the code worked for a while , then as usual Google updated the API and I quit trying to fix it.

GAH!  So frustrating...  what did you end up doing instead?  

so, I just built a spreadsheet of sorts in my scheduling, googled the address1 and then used the directions / time for address 2, same for address 3, then built my day for each field tech so that they would not be late. It's not pretty, but it's functional.

Google Maps has an API that can give you drive time and distance between two addresses. Here's a brief snippet from ChatGPT, but if you guys want, I can make a video out of this. It's pretty cool stuff:

The Google Maps Distance Matrix API is exactly what you're looking for. It lets you input two (or more) addresses and returns:

* Driving time (duration)
* Distance
* Multiple travel modes (driving, walking, bicycling, transit)
* Optional traffic-aware estimates

Here's a quick overview:

Endpoint:

Code

https://maps.googleapis.com/maps/api/distancematrix/json
Copy

Sample GET request:

Code

https://maps.googleapis.com/maps/api/distancematrix/json?origins=1600+Pennsylvania+Ave+NW,Washington,DC&destinations=1+Infinite+Loop,Cupertino,CA&key=YOUR_API_KEY
Copy

Parameters:

* `origins`: one or more addresses or lat/lng pairs
* `destinations`: same as above
* `key`: your Google API key
* Optional: `departure_time=now` for traffic-adjusted results

Returns JSON like this:

Code

{
  "rows": [
    {
      "elements": [
        {
          "distance": { "text": "2,842 mi", "value": 4573452 },
          "duration": { "text": "41 hours", "value": 148320 },
          "status": "OK"
        }
      ]
    }
  ]
}
Copy

How to use:

1. Go to https://console.cloud.google.com/
2. Create a project and enable the Distance Matrix API
3. Set billing info (Google gives \$200/month free usage)
4. Generate an API key
5. Use a GET request via HTTP or your preferred language (VBA, Python, etc.)

Alternatives:

* OpenRouteService.org - Free with generous limits, based on OpenStreetMap
* MapQuest API - Also supports time/distance lookups
* Bing Maps API - Similar to Google's, but different pricing and key setup

If you could do a video that would be awesome!  I am a visual learner...I bet it would be a very popular video!  Could even bring in more business for you when people see this really awesome and amazing video! Can't wait to see it!  It is gonna be epic!  Just like the most epic Star Trek episode The City on The Edge of Forever!!