Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel query to access database
record a macro while creating the query
Tools-Macro-Macros and select your macro, press Edit go to the SELECT clause and change your filtering condition accordingly from "WHERE (Company Name='Contoso')") to "WHERE (Company Name=" & Range("F1").Value & ")") then use the macro every time you need to generate new data HIH pls click YES if it was helpful On 15 Kwi, 10:53, Piotr wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel query to access database
Dziekuje bardzo za pomoc i pozdrawiam.
"Jarek Kujawa" wrote: record a macro while creating the query Tools-Macro-Macros and select your macro, press Edit go to the SELECT clause and change your filtering condition accordingly from "WHERE (Company Name='Contoso')") to "WHERE (Company Name=" & Range("F1").Value & ")") then use the macro every time you need to generate new data HIH pls click YES if it was helpful On 15 Kwi, 10:53, Piotr wrote: 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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel query to access database
proszÄ™ bardzo
postaw mi proszÄ™ ocenÄ™ (gwiazdki) jeĹ›li Ci pomogĹ‚em On 15 Kwi, 14:40, Piotr wrote: Dziekuje bardzo za pomoc i pozdrawiam. "Jarek Kujawa" wrote: record a macro while creating the query Tools-Macro-Macros and select your macro, press Edit go to the SELECT clause and change your filtering condition accordingly from "WHERE (Company Name='Contoso')") to "WHERE (Company Name=" & Range("F1").Value & ")") then use the macro every time you need to generate new data HIH pls click YES if it was helpful On 15 Kwi, 10:53, Piotr wrote: 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 .- Ukryj cytowany tekst - - PokaĹĽ cytowany tekst - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 query from Access 2000 database | Excel Worksheet Functions | |||
Database query to import from Access to Excel | Excel Discussion (Misc queries) | |||
connect to access database and run a query in excel VBA | Excel Discussion (Misc queries) | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |