Excel VBA Introduction Part 56.6 - ADO Commands and Parameters
Excel VBA Introduction Part 56.5 - Basic ADO Commands
Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets
Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO
Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries
Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files
Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver
Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions
Excel VBA Introduction Part 58.7 - SQL for Excel Files - Basic Calculated Columns
Excel VBA Online Course - 4.3.3 Object Parameters
VBA Macros: Consolidated SQL Queries Through ADODB Connection after considering Excel as Database
Excel VBA Introduction Part 58.14 - SQL for Excel Files - Criteria in the Having Clause
4 Using the Openrecordset method
Excel VBA Online Course - 4.4.2 Function Parameters
Quickly Find Forgotten Commands in VBA - Excel Quickie 43
Wise Owl Answers - How do I get data from a closed Excel file using VBA?
Scripting Dictionary with Ranges
Многомерные массивы в VBA - (Серия VBA 27)
Parsing text files with VBA
