View Single Post
  #44  
Old December 11th, 2007, 07:57 PM posted to microsoft.public.access.externaldata,microsoft.public.access.reports,microsoft.public.access
KP
external usenet poster
 
Posts: 82
Default Creating a custom text export file (inc. header & footer) from a q

Hi "efandango"

I am doing something very similar - would you be willing to share your
query/export specification and the module you used to generate the KLM 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