MapForums

I have two sets of data, Clients and Offices. Can MapPoint be used to create a list containing the office closest to each client, and then export to a file usable by another database application?

Apparently the PushPin Tool Add-in will export a file with lat/long data, but then I still need to compare the two coordinate sets and match based on minimum distance.

Hi,

Of course, Mappoint can be used to calculate distances. But you have
to do it programmatically if you have a lot of addresses.

If you don't want to do it yourself, John Meyer did a batch that you can download or buy in this web site.
All is done in Excel or CSV format , so you can easily use your data in other programs.

Good luck

__________________
Mohamed
www.AtlasCouscous.com

As well as John Meyer's Batch Calculator, I have "MileCharter":

http://www.mapping-tools.com/milecharter/index.shtml

This can work between two different groups, outputting a table to Excel.
Fastest route, shortest route, straight line, etc

out of the box it won't automatically identify the closest or shortest, but if you want this, send a message off-list.


Richard

__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009