Geocode an Address

[Dana F. Brewer]

I've seen the posts about using Google Maps and MS Virtual Earth to locate an
address on a map. Does anyone know how I can get the longitude and latitude
coordinats for a group of addresses. I want to store that information in a
table along with the addresses and then export that data to MS Streets and
Trips.

I have to make driving directions for approx. 30 records at a time from a
list containing several hundred names and addresses. It is tedious for me to
throw all the pins on the map, eyeball what seems to be in close proximity,
and then group those into a select group so I can print directions. I figure
with the coordinates, I could query based on that and then parse just that
data out to the mapping program.

Many thanks if someone can help with this....

Dana

 

[Jack Leach]

A month or two or four ago someone had a question regarding pulling weather
information from a site, and I thought, "hey... you can get the source code
(with the help of Stuart) and then read the file using VBA I/O". Worked
pretty good for an idea out of thin air.

Come to find out, a few weather websites offer xml to help us out with this.
With this in mind, a google of "mapquest xml data" returned a list of sites,
with this first or second link regarding geocoding any address from mapquest
via the mapquest API.

http://devblog.mapquest.com/tag/xml/

Relevant to our interests?? I believe so

I breezed it quickly and saw a reference to a .NET version of code for this
"API", but I don't know about vba. A bit of digging from here may reveal
more.

hth - interesting stuff here, I would be curious to see where this may lead.

("google maps api" and "maquest api" both return some promising looking
links as well)

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)