Not sure if this will help as only glancing at these emails but in vfp I do visit the following URL
http://maps.googleapis.com/maps/api/geocode/json?address=##ADDRESS## using either vfpconnection or the Microsoft html thing ( I can be more specific if required) the ##ADDRESS## is replaced with a postcode for instance http://maps.googleapis.com/maps/api/geocode/json?address=WS98ER You used to be able to do this all day long (there was a throttle that kicked in at some point based on your IP address but the limit was something like 5000 calls a day) These days I believe you need an API key which you would need to pass in with the query to get your JSON back with the lat and lng in. I believe you need a paid for account now but you get $200 dollars usage credit each month for the API which I think for modest usage is plenty. -----Original Message----- From: ProfoxTech <[email protected]> On Behalf Of M Jarvis Sent: Monday, 28 January 2019 19:27 To: [email protected] Subject: Re: Google API for Geocoding ... Again On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail <[email protected]> wrote: > Ok - yes, I'm dredging up a VERY Old thread here! > > So, here's the deal. A woman I worked with for this Jewish Holiday > Pop-up shop here in SF this past late Nov./early Dec. - she wants me > to do a kind of Admin task for her. She's going to give me a > spreadsheet of locations - and wants me to use Google Maps to find the > distances traveled. She then has to note the distances back into the > spreadsheet. > It may have to do with reimbursement based upon mileage. > I did something like this back in 2008 or so and I'm pretty darn sure I posted it here but I'll be darned if I can find it. Maybe your Search-Fu is better than mine so you might be able to dig it up. I used MS Access to do the work but it did the exact thing you are trying to do. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cwlp265mb16684dcf2d3416e0d3d66cf78f...@cwlp265mb1668.gbrp265.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
