Access VBA, Get KML File Data (Google Earth API)
This article explains how to get data from a KML file using VBA for Access. KML files are basically XML files, therefor the process is basically the same as getting data from any other XML File.
The method uses the MSXML object. I’ve explained how you can get data from an XML file on the web using the MSXML object in the article below:
The same concept can be used to get data from the KML File. The tricky part is figuring out which child node contains the data we are after. Fortunately I’ve already done that for you in the code below.
Note: In order for the code to work you will need to add reference to the Microsoft XML Library (Microsoft XML V6.0 was installed on my system):
You can download the sample file used in this article from the link below: