Retrieve Data From A Database To Excel Using SQL
This article shows how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings. Examples of Where this Function Shines: Works well for retrieving data from Access (or