Share via

Query Parameters from Excel to Access

Anonymous
2011-11-05T18:34:32+00:00

Hi 

I have a table in Access 2007. My users would be using Excel 2007.

I want users to filter data by choosing the column headers, criteria, aggregate function (sum / count etc) and group by clauses from within Excel 2007. ( I can provide all column headers of the table in Excel)

How could i then execute the query based on the conditions selected by the user.

So far what i have researched, I can connect to a access query & pass a criteria parameter...but dunno how to select columns / aggregates / group by clauses.

I would also like that when any of these values change in Excel (ie the user selects some different query conditions, the data should automatically get refreshed.

Help

Nikhil

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2011-11-06T15:21:22+00:00

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest