Options
Excel query to access database
Hi,
Could you help me to find solution for my problem please?
I’m not very good in Excel and Access but have to create Excel spread sheet which will take data from Access DB. I almost done it but have one problem which not able to find solution.
When I create query in Excel using “Query Wizard” there is a step called “Filter Data”. I would like to use filter for the table like that: Company Name – equals – Contoso. My problem is that instead using “Contoso” I would like to take value from filed in Excel document (like $c$2).
Is it possible? How to do this?
Thank you and Kind Regards
Could you help me to find solution for my problem please?
I’m not very good in Excel and Access but have to create Excel spread sheet which will take data from Access DB. I almost done it but have one problem which not able to find solution.
When I create query in Excel using “Query Wizard” there is a step called “Filter Data”. I would like to use filter for the table like that: Company Name – equals – Contoso. My problem is that instead using “Contoso” I would like to take value from filed in Excel document (like $c$2).
Is it possible? How to do this?
Thank you and Kind Regards
Comments
-
Options
PiotrIr
Member Posts: 236
The issue is sorted, I got the solution. If somebody is interested in please look:
Daily Dose of Excel Blog Archive Parameters in Excel external data queries