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