Excel Driven Access Queries
I'm trying to use VBA to
1. Update a query in Access based on Excel based input
(i.e. an updated array(X) contains new data points to
filter against). In other words, how do I reference an
Access database and 'talk' to it? Does it need to be
open?
2. Once the query has been run, import the updated query
data into a worksheet in Excel.
Any starter advice/steps/code would be greatly
appreciated.
Thanks.
|