Excel upload to Google maps (1 Viewer)

pekajo

Registered User.
Local time
Today, 20:18
Joined
Jul 25, 2011
Messages
74
Hi,
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.
Peter
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 09:18
Joined
Jul 9, 2003
Messages
12,286
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