Managing Data with Microsoft® Excel

Using ADO to Execute Action Queries and Stored Procedures

If you prefer to use ADO instead of DAO (or if you're not using a Jet database so that DAO isn't available), you'll need to adjust your VBA code to make use of ADO objects. The examples in this section use ADO's Command object which, along with the Connection and the Recordset objects, is one of the three fundamental objects in the ADO model. You generally use the Command object when your code will execute an action query—more broadly, a stored procedure.

NOTE

ADO tends to follow SQL Server terminology in this area, and SQL Server uses the term stored procedure instead of action query. The two terms are not synonymous, however: SQL that Access would term action queries constitute part ...