How to Inject latitude and longitude into a huge Access db
Posted on 2011-03-15
I currently own a huge Access database with 60.000 records.
Those records have a Name, Address, Area, Postal Code, Phone Number
I want to find the longitude and the latitude of the Address field witch is linked to the Area.
So we have the following schema:
32, Example Street, New York.
I know that i can manually search and add the long/lat into the db, but with 60.000 records this could take a lifetime.
Is there an easier way to do this? Maybe with a php/mysql script, but i don't know how. Can i convert the Access Database to mySQL an do this using a PHP script?
I know that this could generate errors in location, but if we link the postal code to the above schema it's possible to eliminate this.