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 -
|