Using the Excel Add-In (VBA)
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.
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.
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.