The following sections walk through creating an example macro that shows how to execute SQL in VBA. See Invoking UI Elements to automate the functionality available on the CData ribbon.

Connecting from VBA

Define a connection and initialize an ExcelComModule. See Connecting from VBA for a guide.

Querying Data

Execute SELECT queries. See Querying Data for examples.

Executing Parmameterized Queries

Pass arrays as the inputs to parameterized queries. See Executing Parameterized Queries for example code.

Updating Data

Execute create, read, update, and delete (CRUD) operations by calling the corresponding method. See Modifying Data for examples.

Calling Stored Procedures

Call stored procedures through the CallSP method. See Calling Stored Procedures for more information.