I don't know of anyone who has specifically done this, but it certainly can be done. The only question would be performance, which would mostly depend on the size of the datasets. If dataset 1 has x records and dataset 2 has y records, you'd have to do x*y calculations of distance.


While lat/lon would be helpful for importing the data, it is not necessary. The Distance method will work using the Location objects of any 2 Pushpins. Check the programming help documentation. This assumes you want a crow's flight distance. If you want a driving distance, you will need to create a route by adding pushpins as waypoints, then calculating the route and reading the Distance property.


- Walt Cygan