How do I geocode in Access 2003?

  • Thread starter Thread starter dudley
  • Start date Start date
D

dudley

I have a database that has roughly 352,000 address I would like to see on a
map. I have found a place that will let me geocode them in batches of 5,000
at a time. Because it takes 45 minutes to an hour per 5,000 I was hoping I
could find out how to automate the process within Access 2003 without me
having to break the addresses into so many pieces.
 
A few years back I was looking at the feasibility interfacing Access with
Microsoft Mapoint using VBA. Basically getting information from an Access
database and using Mapoint to display the locations. The project fell through
and never even made it to a real proof of concept. As I recall, I didn't have
any real issues with buidling the code that I did play with.

The biggest challenge will be the learning curve invovled with understanding
the Mappoint Object Model. Working with another application via automation
isn't that difficult - as long you understand the Object Model. If you don't
have the time or prior experience with VBA, I'd go with whatever other option
you were looking at. To that end, if you do need to break up the 352,000 in
the 5,000 batches, that's also entirely do able via VBA as its just a matter
of cycling through 5,000 records at a time.
 
From the very little I have seen online of MapPoint, it doesn't seem to allow
me to be able to pull up something similar to Google Earth's "Street View".
I am needing to be able to pull up some way to check out how well the
neighborhood takes care of their yard and whatnot before I drive somewhere to
look at in person. Obviously I won't be looking at every address, just the
ones I filter out as not being near many other addresses in my database.
 
Back
Top