[AccessD] Longitude/Latitude

Thank you William and others for your responses.
 
Steve Capistrant
Symphony Information Services
scapistrant at symphonyinfo.com
www.symphonyinfo.com
Main: 763-391-7400 ext 801
Toll Free: 888-357-1373 ext 801
Direct:  612-237-0075

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of William Hindman
Sent: Fri 9/29/2006 5:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Longitude/Latitude



...reference tables abound ...including high quality free ones ...start
here, but there are plenty more
http://spatialnews.geocomm.com/newsletter/2000/jan/zipcodes.html

William Hindman

----- Original Message -----
From: "Steve Capistrant" <scapistrant at symphonyinfo.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>; <accessd at databaseadvisors.com>
Sent: Friday, September 29, 2006 5:56 PM
Subject: [AccessD] Longitude/Latitude


> Hello all,
>
> Sorry if this has been asked recently and I didn't pay attention.  What
> options exist for programmatically inserting longitude and latitude values
> on an address record?  I was told that Google had some way to return that
> information from their database, but can't seem to find it (perhaps if I
> paid for a business account).  This is a task I'd do regularly (perhaps
> twice a month) as data gets uploaded from a local Access db into a
> website, where the website is coded to calculate distance between
> addresses.
>
> Ideally, it would be SO cool to due this by connecting to a website and
> looping through the recordset of an Address table.  But another option I
> suppose is getting occasional downloads of a reference table, and use that
> as my lookup.
>
> Steve Capistrant