Would like to achieve a VB script that creates a webpage using the Google Maps API that visually represents the movement & flight path of an aircraft.
Please see example that successfully does this for two points:
[url removed, login to view]
Using an existing MS Access database, would like to pass an array/table containing longitude & latitude coordinates, maximum of 15 points, which results in a Google Map Overlay within a webpage.
The first point (departure) should have a different symbol to the final point (destination) within the trip. Departure and Destination could be the same point.
So, to summarise, would like VB procedure that can be called from within MS Access that uses the data from within a table/query. The output of this procedure is a text web file that contains all the data to plot the 'Great Circle Path' with Goole Maps.
I have created a similar procedure that writes line by line into a text file, inserting the x & y coords in the right place and then renaming it .htm. I can only do this for polylines. Google have a way of producing curves but the segments are too great and the result is not a smooth line like in the example.
Hope someone can help