First a little background on this project.
Our company has developed a web page for our Inside Sales team that lets them enter a Zip Code and it returns the District Manager that is responsible in that area.
Currently we use Microsoft's MapPoint software to map the Sales Regions and Districts. Once we have the area mapped, we export the data to an excel spreadsheet for upload to an SQL database for the Web Site to utilize.
However, over the past few years of doing this I learned that not all of the postal codes are exported. I have had extensive conversations with Microsoft and they explained that this was a limitation of the software. All available Zip Codes are displayed in the software but only the ones listed as "Primary" in the coding are available for export. This leaves about 15,000 zip codes out.
So I developed a process that involves a lot of tedious look-up and manual correction for the missing zip codes.
What I really want to know is, does anyone know of any software that would allow me to tie into an SQL Database, that would allow a user to make corrections to a Geographical Gui (like MapPoint), that would in turn update the Database providing a complete list of Postal Codes that we could use to update the Site for our Inside Sales team.
We also use this data for Marketing Campaigns and other geographical systems throughout the company.
It would also need to be able to map Canada and Mexico.
I have done several searches and found several programs, but very few tie to SQL.