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,

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,

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,

that's not true either. Looks like you are building your own obstacles to
reaching a solution:

http://nickhodge.co.uk/gui/datamenu/...taexamples.htm

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

--
Regards,
Tom Ogilvy

"Nagesh" wrote in message
...
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,