October 10th, 2015
vba2010

VBA 2010 – 091: SQL Parameters

SQL Parameters are the solution needed in order to overcome SQL Insertion

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 – 090: SQL Insertion

VBA 2010 – 092: SQL Multiple Parameters

One Comment

  1. Greg
    March 25, 2015

    Great video. I’m getting an error on rs.open cmd. “[Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.” I’m using another excel sheet in the workbook as my data table instead of MS Access as you are using. I’m positive that I have the connection set up correctly because I am able to run other queries without using ADODB commands. My SQL statement is “SELECT * FROM [Users$] WHERE [Name]=@UserID” Users$ being the sheet that is the data table and Name being the field in the data table. Any thoughts? Thanks!

    Reply

Leave a comment

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