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!

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

"Mike" wrote:

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!