Verify customer address

[ettienne]

I have to verify customer's address and ZIP codes on a database of about 10,000 records.
Some customers have invalid or blank ZIP codes and others have incorrect street address details. We're hoping to resolve most of the ZIP code errors and then deal with the incorrect street addresses manually.
There are a bunch of web sites that you can search for address information and get the correct details, so my thinking was to write something in VBA to query a website and then use the results. I'm stuck with VBA because that is all that is available at the client.
My web/html/xml skills fall short of actually getting anything working.
I was hoping someone could point me in the right direction.

 

[ettienne]

Found a working example:

Add Microsoft XML v6.0 to References.

Function GetGeocodeXML(address As String) As String
    Dim xmlHttp As New XMLHTTP60
        
    xmlHttp.Open "GET", "[URL unfurl="true"]http://maps.google.com/maps/api/geocode/xml?sensor=false&address="[/URL] & address, False
    xmlHttp.send
    GetGeocodeXML = xmlHttp.responseText
End Function

 

[PHV]

And the problem is ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886