Lat/Lon data source for addresses
Posted on 2012-03-22
Hi Experts, I have been given an assignment of taking a list of addresses and determining the lat/lon for them. I'm at a bit of a loss as to how this can be accomplished. I did see a previously entered note here which did the job in HTML for a single address. I didn't understand how it was accomplished. The best solution for me would most likely be an Access DB solution (I have 2010 installed on my PC but I think that the work would most likely be done in Access Basic (I'm familiar with Access 2007 Basic, not 2010 if there's any difference)).
Anyone have an idea as to how I can do this automatically instead of just typing in addesses manually into Google Maps and cutting and pasting the lat/lons into the list?
PS For this process, let's assume the list of addresses I have will be in tab delimited format. I can work with Acess Basic, Office VBA and I'm rusty in VB6. I also have access to SQL Server but am just learning that now. My strength is Access.