May 26th, 2022

VBA 2010 – 072: Recordsets

This tutorials shows you how to use recordsets to store the output of SQL Queries.

Download the samples for this series for free!

All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.

Recommended Reading

Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.

If you have read any books and feel they are worth recommending then please post about them on our Forum.

VBA 2010 – 071: ADODB

VBA 2010 – 073: SQL WHERE


  1. Senthamarai R
    January 4, 2016

    hi Matt,

    I am trying to connect Composite server from VBA. but getting “The object invoked is disconnected from client ” error. can you please give me the example for “connection string” and recordset object.


  2. Jeannie Ramirez
    October 14, 2019

    Hi. i try to run the code in the video and i get an error Automation error runtime error -2147217865. can you help please.


Leave a comment

Your email address will not be published. Required fields are marked *