View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Piotr Piotr is offline
external usenet poster
 
Posts: 2
Default Excel query to access database

Hi,

Could you help me to find solution for my problem please?

Im 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