Importing Data from Excel to Google Maps??

gkirby

I am new to this community. I am trying to import data from excel to google maps. The data contains names, addresses, city and zip codes. There are approximately 3500 on the excel spreadsheet. can anyone help me with this process?

Regards,

Greg

Virgil Dodson

Hi Greg, If you are trying to get Excel data into a BIRT report (so you can then link it to a Google map) there are a couple of ways you could do it. <br />
<br />
First, I've seen a JDBC driver for Excel files... you could download that driver and add it to your BIRT enviroment (inside the Data Source wizard)<br />
<br />
If that driver is not flexible enough for your needs, there is a free Excel read/write Java API available from Actuate that will let you write a small Java class to get the Excel data.<br />
<a class='bbc_url' href='http://www.actuate.com/products/spreadsheets/spreadsheet-api/for-developers/'>BIRT Spreadsheet API - For Developers</a><br />
Then you use the BIRT Scripted data source to get at the data.