Excel data to Google Earth kml

  • Thread starter Thread starter Manosh
  • Start date Start date
M

Manosh

Hi,
I would like to export a list data from an access database based on a
filter to view in Google Earth.
Within google i need a simple place holder and a short description.
I have found some links that suggest that there are tools in excel
which could convert this on the fly for me but unfortunately many of
the sites seem discontinued.
Would anybody be able to help please?!!
Many thanks
Manosh
 
Hi,

Don't know anything about kml? Possibly you want to save the Excel file as
an XML file type. If so choose Office Button, Save As, and from the Save as
type drop-down pick one of the XML formats.
 
Bonsour® Manosh avec ferveur ;o))) vous nous disiez :
Hi,
I would like to export a list data from an access database based on a
filter to view in Google Earth.
Within google i need a simple place holder and a short description.
I have found some links that suggest that there are tools in excel
which could convert this on the fly for me but unfortunately many of
the sites seem discontinued.
Would anybody be able to help please?!!
Click to expand...



Why to export ????
if your list are coordinates like :
N50.32436 E3.245
or
1111 S Figueroa St Los angeles

;o)))
then

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Dim Location As String
If Not Intersect(Target, Range("Coordinates List")) Is Nothing Then
If Target.Cells.Count = 1 And Target.Value <> "" Then
Location = "http://maps.google.com/maps?q=" & Target.Text & "&spn=0.001,0.04&t=h&iwloc=A&hl=us"
Internet Location
End If
End If
End Sub

;o)))
HTH
 
Back
Top