PDA

View Full Version : how to do a variable odbc/.mbd database query



dragonisfury
12-02-2005, 01:59 PM
What I am doing is calling information from a .mdb file on a shared network drive. I want to query this database for all field where rectype is equal to a commandbox entry and where the period/month is equal to a commandbox entry. I have tried several different attempts but I cant seem to get excel to modify the query it just wants to refresh an existing one. Any one understand what I am trying to do enough to help me out?

Norie
12-02-2005, 02:31 PM
There's a whole section in Excel help on using parameters (from various different types of input) with external data queries.

It's quite comprehensive, so I suggest you take a look at it.

dragonisfury
12-02-2005, 03:49 PM
Thanks that section gave me some good ideas.