Tom,

Adding a criteria there would require value to be provided in a popup
window. I am looking for value to be picked up from a cell which is my active
cell.
Thanks,


"Tom Ogilvy" wrote:

Get External Data supports adding a criteria. In MS query, look in the menu
when you set up the query.

--
Regards,
Tom Ogilvy


"Nagesh" wrote in message
...
Hi,

I have written code to import data from Access to Excel using VB code
since
I wanted values to be filtered on a value. I picked up this code from MS
site
which used ADODB for connection. I found that this code was not working
properly despite choosing proper references.
Is there a simple way I can get data from Access to excel 2003 filtred on
a
value which is stored in adjacent cell. (If I use get external data in
Excel,
it dumps the entire table).
Appeciate your response.

Thanks,