Category: Access

Creating an Access Database (on the fly) Using VBA and SQL

I recently had reason to create a database on the fly if one did not exist. Since it took me some trial, error and searching (and then more trial and error,) I decided to share the method to do this.

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