I am trying to get the network distance from a large number of student locations to their school. I have about 40k students and about 85 school locations. I would like something like the OD Cost Matrix, but I don't want every single combination - e.g. I only want the distances to the school they are attending (school # can be found in the student attribute table and the facility information). Is there a way to link the Origins and Destinations by a common field (School # in this example)?
The most likely reason the solvers are grayed out are these two: 1. You did not enable the extension. Use the Customize drop down and then pick Extensions and make sure Network Analyst is turned on. 2. You have not added a network dataset to the ArcMap table of contents. Without any street network data you can not perform any analysis. If you do not have any data, you can look at using the free streetmap data that comes on the Data and Maps dvd.
The Data and Maps DVD content is available online by first logging into the customer care portal at customers.esri.com You can download the streetmap network data from there. Or if you have the DVD handy you can copy it from there.