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.