excel and mappoint

[Mike]

I need to create a solution that takes an excel spreadsheet and looks at the
city, state and zip code columns and creates a link in the name column to
mappoint so the user can automatically bring up a map of where this person is
currently located. I am trying to figure out how I can do this.
My thoughts are that I am going to have to do this on our intranet site so
the user will import the spreadsheet to a table on our sql server database,
then I will have to code the links into the spreadsheet in the background and
export the spreadsheet with the new features for the user. I am not sure if
this is the best way to do this and I have not had any luck finding the
information I need to code this into the spreadsheet.
If anyone could give me suggestions on a better way or point me in the right
direction to how to code this it would really help me out.
Thanks!

 

[Ron]

Hi Mike,

I've had similar problems in writing code to import data from excel to
mappoint. An alternative I found however, not quite as useful is the MapPoint
COM addin. This inserts a button on the excel toolbar which opens a mappoint
map inside excel next to all your data. From here it is very simple to change
the info and update your map.

Its not ideal, but I hope it helps - it certainly saves on those hours
slaved over VBA too!

Ron