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.