Linking GE to an Access Database by generating .KML

[abhinav]

Hey All,

I am new user of GE. Actually I have created an application in VB which has an Access Database as backend, where I perform calculations for each location. I have 4 configurations for each location and I calculate some costs for each of them. Right now I am generating a KML using this VB code, but thing is that its displaying all the costs corresponding to each location in four different ballons, so I am not able to compare which configuration is better by looking at these balloons. These are four different records in Access database with same location. I want to display all these in one balloon in some kind of grid manner, so that its easy to compare values. If seniors can let me know if there is some formating I can do to display the info in balloon, then I will be very thankful.

Please let me know if you want more info.

[bobbyp]

Abhinav,
I'd be interested to hear how your link to Access from GE is working. I am not a programmer, but a GIS guy using a MS Access point database and MapInfo.

I'd like to be able to find a way to link Access and GE together so that any edits made in GE would update in the database and vice versa. I've been searching a little and there doesn't seem to be a ready-made app or ODBC connection for this...and I am not a programmer!

Please, let me know if you have any ideas on how to do what I'm talking about.

Much obliged,
BP

[Forkboy2]

Sounds like you need to concatenate your 4 sets of data into a single record before generating the KML code. You should be able to use standard HTML table formatting from there.

[lasersguru]

Your post rocks!

[adnanrao]

Your post rocks!

thats right

[adnanrao]

Hey All,

I am new user of GE. Actually I have created an application in VB which has an Access Database as backend, where I perform calculations for each location. I have 4 configurations for each location and I calculate some costs for each of them. Right now I am generating a KML using this VB code, but thing is that its displaying all the costs corresponding to each location in four different ballons, so I am not able to compare which configuration is better by looking at these balloons. These are four different records in Access database with same location. I want to display all these in one balloon in some kind of grid manner, so that its easy to compare values. If seniors can let me know if there is some formating I can do to display the info in balloon, then I will be very thankful.

Please let me know if you want more info.

mmmmmmmmmm

[Captain Hornblower]

adnanrao, anything you want to tell us... :stare: