Peter, why extract a csv file when you can use your access database?
(or in the GIS 'ESRI' field an .mdb is a Personal Geodatabase)
Does your access database contain lat&lngs?
If so you can use this in .asp to generate an .xml which can then be
parsed with Google Map API
This from the original post
here is how I pulled the lng/lats out from my cornwall.mdb
(geodatabase/access file)
and made an xml file from it.
<%
response.ContentType = "text/xml"
set conn=Server.CreateObject("ADODB.Connection")
conn.provider="Microsoft.Jet.OLEDB.4.0;"
conn.open server.mappath("/gmap/gdb/cornwall.mdb")
sql="select POINT_X, POINT_Y from cornwall"
set rs=Conn.Execute(sql)
rs.MoveFirst()
response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
response.Write objXmlDoc.xml
response.write("<cornwall>")
while (not rs.EOF)
response.write("<marker>")
response.write("<lat>" & rs("POINT_Y") & "</lat>")
response.write("<lng>" & rs("POINT_X") & "</lng>")
response.write("</marker>")
rs.MoveNext()
wend
rs.close()
conn.close()
response.write("</cornwall>")
%>
What do you do withe .xml now its created??
Mike Williams has the answers
http://www.econym.org.uk/gmap/basic3.htm
If you do want to use your csv file then you can use this example
http://www.econym.org.uk/gmap/basic9.htm
or Esa has a few examples...
http://mapsapi.googlepages.com/textmarkers.htm
or if you don't have your data geocoded (lat/lngs) then you can upload
it to google spreadsheets
http://apitricks.blogspot.com/2008/10/geocoding-by-google-spreadsheets.html
Mapperz
http://mapperz.blogspot.com/
On Jan 15, 3:51 pm, Peter <[email protected]> wrote:
> I've got a database of customers that I'd like to be able to display
> on a map as pushpins - a sort of "here they all are - look at those
> lovely clusters mwahaha" sort of thing.
>
> I figure the best was, given that this data is in an Access mdb would
> be to export the postcodes as a CSV list, and then somehow feed this
> into Google Maps, but I can’t find any apps that can do this, and I
> have next to no programming skills outside of VBA – can anybody
> provide me with pointer as how I might be able to do this? This isn’t
> a commercial application – I just think it would be kind of cool and
> I’d love to use it as a way of maybe picking up some API skills along
> the way...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---
