Download this demonstration of many useful techniques for using Microsoft Excel, VBA, and ADO with the Access Database Engine to work with CSV (comma-separated values) files, Access databases, and SQL Server databases.

• Use ADO to make connections to CSV files, Access databases, and SQL Server databases in VBA.
• Perform an SQL Join operation on multiple related CSV files.
• Use parameters to build dynamic SQL queries in VBA.
• Use records in a recordset to build a collection of objects in VBA.
• Use hierarchical collections of objects in VBA to build a hierarchical Excel worksheet with collapsable rows and columns.
• Create an Access database from multiple related CSV files.
• Many other useful techniques …