Measuring Distance using FSA

Discussion created by coultetr on Feb 13, 2014
Latest reply on Feb 14, 2014 by curtvprice

I'm very new to ArcGIS so please forgive me if this question is overly simple (or, conversely, impossible). I have a large number of records in an Excel file that include record number, one FSA (the first three digits of a Canadian postal code) and a second FSA. Using the FSA Boundary file - available at I have been able to Join the data in the excel table to the features in the Boundary file for one of the FSAs, but not both.

What I'd really like to be able to do is measure the distance between the features for each record, and have then appear them in the table? I.E. the table would have record number, FSA 1, FSA 2, distance between. The suite I am using has the spatial analysis and proximity analysis toolsets, but I don't know how to Join all the records together properly.
I posted this same question in Spatial Analysis earlier but realize it may have been in the wrong category.

Any help or guidance is greatly appreciated! Thanks!