Excel Access interface
Hello
I would like to be able to create a form (or some sort of
interface) in Excel that would allow the user to select
certain perameters, then send these parameters to Access
and run a select query on a pre-existing table using the
selected parameters. I would then like the query results
sent back to Excel and displayed in a (preferably the
same) form that would allow the Excel user to interact
with the results. (For example, select a record store that
meets the criteria of being in CA and selling DVDs as
well.)
Any help is appreciated. Thanks.
|