PC Review


Reply
Thread Tools Rate Thread

How do I geocode in Access 2003?

 
 
dudley
Guest
Posts: n/a
 
      29th Sep 2008
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.
 
Reply With Quote
 
 
 
 
dch3
Guest
Posts: n/a
 
      29th Sep 2008
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.

"dudley" wrote:

> 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.

 
Reply With Quote
 
dudley
Guest
Posts: n/a
 
      29th Sep 2008
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.

"dch3" wrote:

> 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.
>
> "dudley" wrote:
>
> > 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.

 
Reply With Quote
 
dch3
Guest
Posts: n/a
 
      29th Sep 2008
Gotcha - you're looking for a way to look at satelite images. My bad.

"dudley" wrote:

> 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.
>
> "dch3" wrote:
>
> > 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.
> >
> > "dudley" wrote:
> >
> > > 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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
geocode data from Access 2007 Mark Andrews Microsoft Access 0 23rd Dec 2009 02:47 PM
Geocode an Address Dana F. Brewer Microsoft Access Queries 1 28th May 2009 07:15 AM
Geocode an Address Dana F. Brewer Microsoft Access VBA Modules 2 28th May 2009 03:59 AM
Geocode an Address Dana F. Brewer Microsoft Access VBA Modules 0 27th May 2009 07:00 AM
Converting GPS to Digital Geocode =?Utf-8?B?R1JW?= Microsoft Excel Worksheet Functions 3 5th Jul 2007 09:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:05 PM.