Mapping Addresses MS Excel

Posted on 2011-10-31
Medium Priority
Last Modified: 2012-05-12

I work primarily with Oracle and create many SQL reports for our business that they like to have in Excel format. While Excel is not my first choice the business loves the ability to have an easy to understand format.

To that point I have a requirement to create a map, with pushpins, of addresses using the data from my SQL. I was speaking to an analyst and she states that they manually use Microsoft MapPoint right now. Does anyone else have history using other programs or better alternatives that might be more robust with Excel to produce a report with the mapping of addresses?
Question by:mjfigur
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 37059306
Do you have access to the NavTeq database (or others) that convert a street address to the X-Y coordinates (GeoCoding)?

What is our budget?  Oracle has a 'free' MapViewer.  I used air quotes becuase you need an Oracle Spatial license.


Author Comment

ID: 37063531
Thank you I will see if we have such access to NavTeq. Given the team I am on and the organization the budget should not be an issue so long as we can justify its use. I will also look into MapViewer as well. The company might already have it, however it might not be widely known around the organization.

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question