Import Intersections

Is there a way to import intersection locations? I can "Find" intersections, but can't import.

I will be mapping a relatively small set of school bus routes, and many of the stops are located not at specific addresses but at intersections. I intend to use an Access table of stop information to import. I'm hoping I can find a relatively painless way of doing this without having to go in and locate the stops manually. Any ideas?

I thought you could import addresses.. post a few lines of examples and describe your procedure a little bit.

Eric

Eric,

I can import addresses easily enough, but not interesection locations. If, for instance, I try to import an address like:"2150 Springvale Rd., Duluth, MN", it works just fine. But if I try "W 11th St. & N 24th Av. W, Duluth, MN" it chokes out and won't match the location, even though I can type exactly the same thing in the "Find" dialog and it matches it perfectly.

I've poked around the programming procedures and such and haven't yet found anything that will do it. Just thought there might be some sort of workaround that I'm not aware of. If not, MapPoint will not be quite as helpful as I was hoping, though I'll still do what I need to do manually.

Eric,

I missed this part of your question --

I am just using the Import Data Wizard to pull in a very simple Excel worksheet of addresses. Nothing fancy - starting simple to see how things work (or don't, as the case may be). I match the intersection location from Excel to the Address1 field in the Import Wizard. I also tried splitting the two streets into two fields and matching one street to Address1 and the other to Address2, but no luck.

Ah yeah I can't get it either.

If you look in the Help File, there's three programming methods: FindAddressResults, FindPlaceResults, and FindResults.

I think when it's importing or linking it's performing a FindAddressResults.

You could program a custom script to perform the FindResults, here's the description of that.

FindResults method
Returns a collection of locations and Pushpins (FindResults collection) that are possible place and address find matches based on the input string; similar to the Find box on the Navigation toolbar.

If custom programming is not an option or appropriate for your size of job, then manually doing them may be the way to go.

Eric

this example should give you what you are looking for

Private Sub stop_Click()
Dim objMap As MapPoint.Map
Set objMap = Forms!MAPform.MAP.ActiveMap
Dim objloc As MapPoint.Location
Dim addy As String
addy = Forms!csgmAP.addys

Set objloc = objMap.FindResults(Forms!MAPform.addys).Item(1)
objMap.ActiveRoute.Waypoints.Add objloc
'objloc.Goto

Eric & Randy - Thanks to both of you for checking into this for me. The FindResults option makes sense.

You'll have to forgive my relative lack of VBA programming skills here, though (I'm learning, but way too slowly for my own tastes). Where would I attach this code? My primary goal at the moment is to create an Access database that includes a table of bus stops that are uniquely identified and that are assigned to a uniquely-identified route, and from that table, use a query to pull a list of stops by route to create a MapPoint dataset. In MapPoint, I could then sequence the stops to create the route and route directions. How would I adapt this code to accomplish that goal? (Note: I haven't even started building the database yet - just doing some preliminary planning and research here, in hopes of getting it close to right the first time.)