read some of this tutorial on ADO. You don't have to read everything. Focus on the connection object and recordset object (see section called "Getting data")
One way to use Access is not only to store the data in it, but also the queries that you require (can be parameter queries). article here on how to create the queries from Excel. Now you don't have to create them from Excel but the code does show how to create the connection. And what may be of further use is the part that describes how to run queries in Access.
Finally, the most common way of dumping data from an ADO recordset to a range is by using the CopyFromRecordset method, so have a look at that.
No comments:
Post a Comment