I want to integrate Geocoding into an Access file, but I'm not sure if this is even possible. I honestly do not know much about Web programming, so I might be missing something fundamental.
Maybe a bit more info might help. Sound like a fun project we could get involved in. What do you want to do with the data? How do want the data displayed?
Feel free to copy/paste this into a new file, name it xy.kml, and then open it with Google Earth
Okay. Now, those geocoding coordinates are typically not available in a company's database, whereas address data is. So currently, you have to take the address data from the access table mentioned above, and go to a batch geocoding website such as http://www.wotton.org/map/batchgeo.html
to obtain the latitude and longitude.
This is a really painstaking manual process, as imperfect or strangely formatted address data won't lead to correct results, requiring several passes, trying only the ZIP code etc. Plus it relies on some obscure free website
Therefore, I want to automize this, and do the geocoding directly from Access, and write the results in the table. Based on the return codes from Google Maps, you can know whether you found the right match, and do all kinds of CASE, IF/WHEN or similar routines to make sure the best possible coordinates are obtained.
I hope this gives you a better picture, and maybe you can even come up with some pointers on how to approach this.
Bani