Importing data from Access to Excel 2003 using code

[Guest]

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

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

 

[Guest]

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]

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

http://nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

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