A
AG
Hi All,
I store my raw data in access database. This database gets updated on
daily basis with the information from previous day. I have a dashboard
in excel for management reporting purpose. For the review purposes we
also need to extract the raw data from Access database into Excel
spreadsheet based on the queries. Is it possible to write the queries
in such a way that the parameters (fields of the tables in Access
Database) of the query can be defined by the user as cell values
(using drop down lists etc.) in Excel and then using macro we can run
the query based on those parameter values.
I will appreciate if anyone can help me with the same. Thank you.
Regards,
-AG
I store my raw data in access database. This database gets updated on
daily basis with the information from previous day. I have a dashboard
in excel for management reporting purpose. For the review purposes we
also need to extract the raw data from Access database into Excel
spreadsheet based on the queries. Is it possible to write the queries
in such a way that the parameters (fields of the tables in Access
Database) of the query can be defined by the user as cell values
(using drop down lists etc.) in Excel and then using macro we can run
the query based on those parameter values.
I will appreciate if anyone can help me with the same. Thank you.
Regards,
-AG