Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database

By Andrew Gould

You can download the Access Movies database here:

You can download the script to create the SQL Server Movies database used in this video at the following link:

[MakeItHappenWithVBA]

Thank you so much once again. I have figured out the your channel is not only designed for beginners but to intermediate and advance as well.

Your ADODB tutorials and Scripting Runtime serves as an eye opener. I have followed your channel for a decade already. I hope you still continue your C# tutorials, who knows, your videos will benefit more people in the future. ☺️☺️☺️

[kunalnagpal]

Every student needs a teacher like you sir hatts off to you....

[MakeItHappenWithVBA]

I have watched this video 7 years ago and moved my VBA skills to the next level. This video inspired me to explore more about VBA. This tutorial helped me a lot to create a structured dll. I thought this was too complex to understand but after understanding the concept of class modules, it is just simply amazing. Thanks Mr. Andrew. By the way sir. I am the one who always asks you about using VBA to connect to Google Sheets and Drive if you still remember. I want to tell you that the first dll that I created was the dll that connects VBA to Google Sheets API. You are my inspiration that I even mentioned your channel to other channels how good you are. Thank you.

[peterhontaru]

Love how you always show as many possibilities and then say the advantages and disadvantages of each. Many thanks for your time!

[cormackeenan]

Andrew is head and shoulders above 90% of the video purporting to explain the machinations of the topic Andrew covers.

[madebykarmolina]

I have watched many tutorials on VBA and this has the best information I have found packed into a single video. Your method of teaching and explaining WHY you are doing certain things is terrific. I'm certain you saved me hours of time trying to figure out why the code doesn't work once I give this to others by simply explaining what happens if a user doesn't have the ADODB reference library. Thank you!

[bruce]

I'm with Stan on this one. My first experiences with office were in Access and up until the past couple of years when I really began playing with Excel I knew much more about Access. I have connected this way before, but I had lot of problems and was basically copying code and never understood why I had problems and in some instances when I got it working I wasn't sure what it was that I did that actually worked. You explain what is going on so well and give us resources we can use to learn more. Really appreciated, thumbs up and voted as usual. I've looked around for years trying to find videos like yours. Most videos I've watched confused me more than they taught me. Please keep up the good work.

[jimbor]

Beginner here. This was the best tutorial I've ever seen on YouTube. Thanks heaps

[chiragraval]

World Need to Learn That How To Teach any subject from you., you have gifted techniques to teach anything...Just Supper..God Bless You.

[chasejr]

This is the best tutorial regarding Connecting to databases in VBA.

[frankratliff]

As an IT intern I have to say thank you so very much! Your video helped me out quite a bit as just looking online for ado guides wasn't quite helping. THANK YOU! will definitely recommend your videos to others!

[markjauncey]

One of those Holy Grail videos that once found makes everything so much clearer. I've sort of muddled through over the years, but now I actually feel that I understand the ADO process. Thank you so much!

[luvomsengi]

Your vba excel videos has made my work very easy.Thank you

[amminadab]

This is awesome and presented so well. I have been using some ADO code on and off for a little while but not really proficient enough to have confidence to use it more.
I see so many benefits across applications, so I have started investing time into understanding it better and using it regularly.
Thank you so much, this video has helped me get a greater understanding of the why and how.
My best part was when you explained their where Query Wizard (Editors) in SQL and Access, I never knew but simply amazing.

[alexanderwohl]

You are bizarrely gifted at making tutorials.

[chiragraval]

Supper Tutorial, Just first time shown with Proper Error Handling in ADO tutorials till now on the web,

[data-science-ai]

You are awesome. I've grown so much as a developer and you're videos have been essential for me. Thank you.

[rodrigomizumoto]

Hey man! thanks for sharing your knowledge and congrats for your great work on this! Not only I'm learning a lot about VBA, but watching your lessons is a great way for me to improve my english listening skill too. Your pronunciation is absolutely clear and easy to understand. Greetings from Brazil!

[sharminfariha]

This is absolutely a gem of tutorials! Andrew, you are just awesome instructor, man!

[ikennaudeani]

your videos are so wonderful. I cant take my attention off not even for a sec. Andrew Gould you are such an amazing tutor!!!