Transforming Access data to KML

[Elizabeth Sigman]

I have an Access database of organizations with geographic locations (name, city, state) that I'd like to export to XML (which I know how to do) and use an XSLT to transform KML. The markers can be located later, but I'd like to have the transform have some way to locate them in a string so they're not on top of each other. Then they can be easily seen and relocated by hand. I know that I need to use FOR EACH but I'd love it if someone else has struggled with this and has an example.
Thanks.

[Shashi Sadasivan]

I have an Access database of organizations with geographic locations (name, city, state) that I'd like to export to XML (which I know how to do) and use an XSLT to transform KML. The markers can be located later, but I'd like to have the transform have some way to locate them in a string so they're not on top of each other. Then they can be easily seen and relocated by hand. I know that I need to use FOR EACH but I'd love it if someone else has struggled with this and has an example.
Thanks.

Hi,
I had an exact problem, especially when the locations were based on a locality basis, if i got 10 users in the same locality, all of them were right above each other.
I figured out that if you do use a for loo / foreach you wud have to recursively make sure that the current marker you are locating isint going to be right oon someone else.
So I took the easier way around. - Randomization :)