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 click it to 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.
I am new to mappoint and I know vb and excel. 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.