I am trying to figure out if MapPoint 2004 will import from excel the following information:

Have a street segment and the first and last cross streets.

(e.g. James Street from King Street to Wellington Street)

What I'm trying to achieve is for MapPoint 2004 to read the xls spreadsheet and plot out a line segment on the map. Then if possible, export the line segment with the lat and long co-ordinates. I have several hundred segments to do across Canada.

Anybody done this or can this be done in MapPoint 2004?

Curious

Hi,

I'm not sure what you mean by 'plot out a line segment', but you can read the excell in your program, let handle mappoint what you wants it to do and write again yourself in your program to the excell sheet.

Hi,

What I'm trying to do is having a spreadsheet that has a street name in one column and then two subsequent columns
with the first cross street and second cross street. In other words a street segement. If I can import this
information into mappoint from excel, then I would like instead of pushpins, mapoint to draw a route on the road
segement from the first cross street to the second cross street. Once I have this route drawn on the map, then if
possible could I export the lat/long or any other type of reference information back to excel so the reference could
be used in other mapping program

Import / export is not a problem, also you can do a lot in VBA like drawing the road segment. However there is 1 main problem, you dont have the coordinates of the crosspoint itself (or do you ?).

If you ask mappoint to draw a route from a street to another street, I think it will draw it from the middle of the street or maybe one of the endpoints, but a crosspoint I dont think this can be done without coordinates.