I am trying to create a grid of distances from a set of address data (either in Excel or Access or even as delimited file). That is, how far are my customers from each other.
The input data has the following fields:
CustID***Address1***State***ZIP
I need a grid in the following format:
CustID1***CustID2***Distance
Has anybody done anything similar? Any pointers on how to do this will be greatly appreciated.
Thanks,
Satish