OK... I'm new to the whole data integration thing when it comes to MapPoint and Excel. I work for a trucking company that uses Excel to plan routes for trucks. They enter the data manually into Excel, then, manually enter much of the same data into MapPoint to calculate mileage and delivery times. After that, they enter the resultant MapPoint data into Excel again. (don't get me started on their OTHER inefficiencies)

What I would like to do is create a macro that does much of this automatically. OR, at the very least, exports Excel data to MapPoint in one step. Then, the data could be evaluated from there.

What requirements does MapPoint have for the dataset? Can I get away with just importing zip codes and having MapPoint create mileage info from there? That would be ideal.

Essentially, where do I start?

Any helpful input would be appreciated.

- co