PDA

View Full Version : Export Rotes from MapPoint into Excel



ccm
04-15-2011, 01:39 PM
Hi,

I have a route optimized to meet particular time windows in MapPoint and I needto export the following details back to Excel:

stop sequence number (exactly as last saved in MapPoint)
stop address, city, province, postal code, lat & long
stop arrival time (exactly as last saved in MapPoint)
Ideally, the mileage and the elapsed time will be shown for each stop.

Much appreciated any help in this direction.
Thank you,
Colin

Winwaed
04-18-2011, 12:33 PM
We've been discussing this by email.

The MapPoint "waypoint" has an "anchor" location. This does not have its StreetAddress set - even when it has been created from a street address. Therefore the only option is to create pushpins from street addresses first (ideally with the Data Import Wizard), and then use an addin (eg. my RouteWriter) to export the waypoints and correlate the pushpins at the same time. You can also add your own data fields to the pushpins - eg. contact information such as name & telephone number.


Richard