Incorporate Google Maps Autocomplete for addresses

[Leyton01]

We enter a number of addresses in our database (transcribed from paper forms) and I was wanting to speed up/increase accuracy of entry for our users.

Has anyone successfully incorporated the Google Maps (Places) Autocomplete API into their database? It would be great if the users could start typing an address and then select the correct one to have it stored in the database.

There seems to be a lot of threads about geocoding/reverse geocoding which need a single call to the API with response but not much on the Places Autocomplete API. Although it is a small company I am also not sure if each keystroke is a call to the API and would count toward the monthly limit before invoking a charge or if it is the final 'retrieval' of the compete address. (Looks like there are session options which cover this). There is no need for an image, lat/long or any other contact data to be retrieved other than the address.

 

[Uncle Gizmo]

Not sure this Excel VBA will transfer easily into MS Access but at least it should give you an insight.

Google Places Details to Excel with VBA

I'm trying to get a full detail list of Google places to an Excel sheet by using a Text Search request to Google. So I want to perform an API query (?) by writing a search string to an Excel cell

stackoverflow.com

 

[isladogs]

I have used the Places API as part of a commercial app. UK Postal Address Finder - Mendip Data Systems
However I use it in conjunction with a postal address provider to create 'autocomplete' features such as this

Are you UK based?
If so, you could look at an evaluation version or see if one of my free apps will help you e.g. UK Postcode Address Lookup - Mendip Data Systems

The Google Maps API documentation is very good. Can I assume you've already checked this?
Place Autocomplete | Places API | Google Developers

 

[Uncle Gizmo]

Here is an example which uses Bing maps:-

Complete Excel Address Data with Bing Maps API - Desktop liberation

ramblings.mcpher.com

 

[isladogs]

Those are two good articles by Bruce McPherson. Definitely worth reading