J
jon
Hi,
I want to export a list of customer accounts into a Google KML file, so that
clicking on the file will show all their locations on google earth.
I have managed to generate the correct format of the KML file using a
function I have created in Access97, and the output of the function is
perfectly accurate.
I have then saved the output to a text file ( but added a KML extension) ,
but during the output stage, double quotations are added at the beginning
and at the end of the functions content, and in addition any double
quotations that existed within the string are repeated.
For example
The first line should read
<?xml version="1.0" encoding="UTF-8"?>
But it actually exports as
"<?xml version=""1.0"" encoding=""UTF-8""?>
Here's how I create my KML file using my function
Open "C:\Users\JON.DONKEYNOB\Desktop\GOOGLE_EARTH" & [txt_type] & ".KML"
For Output As #1
Write #1, GENERATE_GOOGLE_EARTH_LOCATIONS([txt_type])
Close #1
The variable txt_type is just a way that my function knows if I want to
export live customers or potential customers from our sales
Any help appreciated.
Jon
I want to export a list of customer accounts into a Google KML file, so that
clicking on the file will show all their locations on google earth.
I have managed to generate the correct format of the KML file using a
function I have created in Access97, and the output of the function is
perfectly accurate.
I have then saved the output to a text file ( but added a KML extension) ,
but during the output stage, double quotations are added at the beginning
and at the end of the functions content, and in addition any double
quotations that existed within the string are repeated.
For example
The first line should read
<?xml version="1.0" encoding="UTF-8"?>
But it actually exports as
"<?xml version=""1.0"" encoding=""UTF-8""?>
Here's how I create my KML file using my function
Open "C:\Users\JON.DONKEYNOB\Desktop\GOOGLE_EARTH" & [txt_type] & ".KML"
For Output As #1
Write #1, GENERATE_GOOGLE_EARTH_LOCATIONS([txt_type])
Close #1
The variable txt_type is just a way that my function knows if I want to
export live customers or potential customers from our sales
Any help appreciated.
Jon