Import a route into Streets & Trips through MS Access Code

[BJ]

Can anyone help me find a way to import a route into Streets & Trips, set up
the route planner to show the route in the order that the import tells it to,
and then display the map?

I am writting a dispatch database that I need to be able to import into
Streets & Trips in the order that the client selects and then display that
order on Streets & Trips. I have a sql that will give me the distance from
one place to the next so that it will tell the dispatcher which is the
closest store to put the new store in line with and that will allow them to
set up the route in Access, but I don't know how to get it into S&T. I could
import it into Excell, but then they would have to set it up manually in S&T
and I would like to do that for them.

Any help would be great.

 

[John Nurick]

Hi BJ,

As far as I know there's no way of programming Streets & Trips: you need
to use MapPoint for that. But I don't know whether Streets & Trips can
import a route from a data file: you're more likely to get a good answer
if you ask in the Streets & Trips newsgroup
(microsoft.public.streets-trips).