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!