Including a posting here, I've found a few resources about using ADO to link Excel to an external Database. My problem is that everything I've found only gives programming examples, but does not explain the methods, properties, etc. that the code is using. I've been able to figure out most of the examples, but I was wondering if anyone knows of a resource which explains the different ADO connection properties and methods etc. I have been able to get the examples to work in my code, but I there are many questions that remain about what exaclty I am doing, and other options/methods/properties that don't show up in the examples I've read.

Thank you,
Viggy

What version of ado are you using? is it Ado.net?

You can go to barnes and noble and read an Access book, or
VB6 Databases by charles williams from Wrox.

Just read the ADO chapter or in the VB6 book read the 1st 2 0r 3 chapters and you'll be a pro.

if u have any more ?s be specific and im sure i can help