Excel VBA Introduction Part 30 - ADO (ActiveX Data Objects) Querying a Database

Excel VBA Introduction Part 31 - ADO (ActiveX Data Objects) Modifying Data with Recordsets

Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)

Excel VBA Introduction Part 51.2 - Pivot Tables using an Access Database

Excel VBA Introduction Part 51.3 - Pivot Tables using a SQL Server Database

Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver

Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets

Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files

Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries

Excel VBA Introduction Part 56.5 - Basic ADO Commands

Excel VBA Introduction Part 56.6 - ADO Commands and Parameters

Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO

Wise Owl Answers - How do I get data from a closed Excel file using VBA?

Wise Owl Answers - How do I loop through worksheets in a closed workbook?

Wise Owl Answers - How do I get data from multiple closed Excel files using VBA?

Wise Owl Answers - How do I loop through sheets in multiple closed Excel files?

Wise Owl Answers - How do I get data from multiple workbooks with one query in VBA?

Wise Owl Answers - How do I populate a listbox using an ADO recordset in VBA?

Wise Owl Answers - How do I get the column names from an ADO recordset?

Wise Owl Answers - How do I get data from a CSV file using ActiveX Data Objects?

Wise Owl Answers - How do I add a filename to the results of an ADODB query?

Wise Owl Answers - How do I populate an array with an ADODB recordset?

Wise Owl Answers - How do I count the rows in an ADODB recordset?

Wise Owl Answers - How do I find the data type of a column in an ADODB recordset?

Wise Owl Answers - How do I refer to a field name with a dot in ADODB?

Wise Owl Answers - How do I import tab delimited files with ActiveX Data Objects?

Wise Owl Answers - How do I select more than 255 columns using ADODB with VBA?