Excel upload to Google maps (1 Viewer)


Registered User.
Local time
, 09:04
Jul 25, 2011
I have just discovered you can upload an excel spreadsheet with multiple addresses to Google maps and it will flag each address.
I can export the data from Access but does anyone know how to automate uploading to Google maps.

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 22:04
Jul 9, 2003
I think you need to use a Google sheet. Upload your data from MS Access to the Google sheet with JSON ... {Alternatively you could export it to a comma separated values file (CSV)} Then use this method to link your Google sheet to the Google Maps:-

Mapping from a Google Spreadsheet

However there's a fly in the ointment. I don't think anyone has written the VBA code necessary to link MS Access to a Google sheet. However VBA code to link Excel sheets to Google sheets already exists, it just needs adapting to work with MS Access.

The code was produced by Bruce McPherson of Desktop Liberation.

Using the Google Sheets V4 API from VBA to integrate Sheets and Excel


Users who are viewing this thread

Top Bottom