I often need to import thousands of records (constantly changing data) into a map. I usually have a hit rate of about 95% or so, but that still leaves ~500 unmatched records per 10,000 database records!
I'm working through this in VB6, and have much of it working, EXCEPT the part about handling the unamtched records. My questions are,
1. can I get a subset of the entire dataset that was imported, but only the unmatched records? How is this done?
2. I'd like to do some SIMPLE comparisons (in code) to see if the street/city/state/zip match up. If so, I'd like to stick a pushpin there anyway.
3. For items that do not match up the street/city/state/zip, I would typically just match the last item in the "Potential Locations" dialog if I were doing this through Mappoint's interface. This turns out to the the ZIP code only match, which is OK as a last resort. Any thought on this?
Thanks in advance,
Mike