http://msmvps.com/blogs/access/archive/tags/Eclectic/Tips/default.aspxTags: Eclectic, TipsenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/access/archive/2010/02/18/excel-to-kml-display-excel-files-on-google-earth.aspxThu, 18 Feb 2010 23:23:59 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1758427Tony2http://msmvps.com/blogs/access/rsscomments.aspx?PostID=1758427http://msmvps.com/blogs/access/commentapi.aspx?PostID=1758427http://msmvps.com/blogs/access/archive/2010/02/18/excel-to-kml-display-excel-files-on-google-earth.aspx#comments<p><a href="http://www.earthpoint.us/ExcelToKml.aspx">Excel To KML - Display Excel files on Google Earth</a>.&#160; “Import a spreadsheet of lat/long coordinates to Google Earth.&#160; Pop-up balloons, icons, and paths are easily created from the spreadsheet data.”</p> <p>It doesn’t take much to create a spreadsheet from Access.&#160; <a href="http://www.mvps.org/access/modules/mdl0006.htm">Modules: Sample Excel Automation</a> - cell by cell which is slow but what you could use for the heading row. <a href="http://www.mvps.org/access/modules/mdl0035.htm">Modules: Transferring Records to Excel with Automation</a> which is very fast.</p><div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1758427" width="1" height="1">AccessTipsEclectic