Thread
:
Creating a custom text export file (inc. header & footer) from a q
View Single Post
#
46
December 12th, 2007, 06:49 PM posted to microsoft.public.access.externaldata,microsoft.public.access.reports,microsoft.public.access
KP
external usenet poster
Posts: 82
Creating a custom text export file (inc. header & footer) from a q
Hi "efandango,"
I'm doing some similar work - would you be willing to share the SQL query
and VB script you used to create the KML file? It would save me a lot of
time...
Thanks for considering.
"efandango" wrote:
I have an address query which ouputs a single field to text strings for
Google Earth .kml file format parameters.
The problem is that the .kml file requires a header and footer text to be
inserted. Does anyone know how I can pre-insert the Header and Footer into a
standard text file, and then save it with a ‘.kml’ extension, for example
‘Addresses.kml’
This is the Header:
?xml version="1.0" encoding="UTF-8"?
kml xmlns="http://earth.google.com/kml/2.0"
Document
nameAddress List/name
Folder
nameLocations/name
open1/open
Output Field: [kml Address]
This is the Footer:
/Folder
/Document
/kml
KP
View Public Profile
View message headers
Find all posts by KP
Find all threads started by KP