MAPPOINT Q & A

Top | Post New Question | Read All | MP2K Asks Microsoft

599 Jason - February 11, 2002

I am new to Mappoint, so this question probably has been answered in the past. I have a set of addresses with the street and city information, but no zip code information. Is there a way I can import this into Mappoint, then export it back out with the correct zip code info? Any help would be appreciated.

Answer:

Sure, with VB code you can use the "FindResults" method to get the PostalCode. You can find code to bring data into MapPoint here. The following code shows how to use the "FindResults" method to get the "PostalCode" property.

Dim objLocFR As MapPointCtl.Location
Dim objMap As MapPointCtl.Map
Dim objFind As MapPointCtl.FindResults
    
    Set objMap = ctlMapPoint.ActiveMap
    Set objFind = objMap.FindResults("SR-520 & 148th Ave NE, Redmond, WA")
    For Each objLocFR In objFind
        Debug.Print objLocFR.StreetAddress.PostalCode
    Next

You could then update a database with the zip code.

I couldn't find a way to do it using the Import Data Wizard, or any other way that would not involve code.

- Walt Cygan

Post New Answer / Follow-up

	MP2Kmag Internet