[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
> 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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>