How do I import an XML (or KML) file

[Guest]

I am trying to import a KML (XML) file into an Access 2007 table, but
everytime I try this process, I get a bunch of seperate tables. Does anyone
know how I can get just the following 'Fields': <Name><address><coordintes>

<name>Wood Green Crown Court, London, UK</name>
<address>Lordship Lane, London, N22, UK</address>
<coordinates>-0.101489,51.599326,0</coordinates>

from the sample file segment below?.


****************************
File Sample

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://earth.google.com/kml/2.2">
<Folder>
<name>My Places</name>
<open>1</open>
<Style>
<ListStyle>
<listItemType>check</listItemType>
<ItemIcon>
<state>open</state>
<href>C:/Program Files/Google/Google
Earth/res/mysavedplaces_open.png</href>
</ItemIcon>
<ItemIcon>
<state>closed</state>
<href>C:/Program Files/Google/Google
Earth/res/mysavedplaces_closed.png</href>
</ItemIcon>
<bgColor>00ffffff</bgColor>
</ListStyle>
</Style>
<Folder>
<open>1</open>
<Placemark>
<name>Alexandra Palace, London, UK</name>
<address>Alexandra Palace Way, London, N22 , UK</address>
<Point>
<coordinates>-0.132861,51.591273,0</coordinates>
</Point>
</Placemark>
<Placemark>
<name>Jolly Anglers, London, UK</name>
<address>Station Road, London, N22 , UK</address>
<Point>
<coordinates>-0.116207,51.59672,0</coordinates>
</Point>
</Placemark>
<Placemark>
<name>Mountview Academy of Theatre Arts, London, UK</name>
<address>Kingfisher Pl, Clarendon Rd, London, N22, UK</address>
</Placemark>


</Folder>
</Folder>
</kml>

****************************