Here is my problem.

I am trying to query a query held in Access 2003 from Microsoft Excel. I
have done this successfully using VBA. The problem is that I dont want the
access query to contain ALL the data so I need to use criteria ( Where
Clause ). This is ok except for the fact that the ODBC Driver returns an
error telling me it requires a number of parameters.

Any ideas on how to get around this

Answered in another thread in this newsgroup. (Subject 'Getting Access Query
Data Into Excel Using VBA').

--
Brendan Reynolds
Access MVP


"Goofy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Here is my problem.
>
> I am trying to query a query held in Access 2003 from Microsoft Excel. I
> have done this successfully using VBA. The problem is that I dont want the
> access query to contain ALL the data so I need to use criteria ( Where
> Clause ). This is ok except for the fact that the ODBC Driver returns an
> error telling me it requires a number of parameters.
>
> Any ideas on how to get around this
>

How are you currently returning the data to Excel ?

NickHK

"Goofy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Here is my problem.
>
> I am trying to query a query held in Access 2003 from Microsoft Excel. I
> have done this successfully using VBA. The problem is that I dont want the
> access query to contain ALL the data so I need to use criteria ( Where
> Clause ). This is ok except for the fact that the ODBC Driver returns an
> error telling me it requires a number of parameters.
>
> Any ideas on how to get around this
>
>

Maybe ?
http://www.rondebruin.nl/accessexcel.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Goofy" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Here is my problem.
>
> I am trying to query a query held in Access 2003 from Microsoft Excel. I have done this successfully using VBA. The problem is
> that I dont want the access query to contain ALL the data so I need to use criteria ( Where Clause ). This is ok except for the
> fact that the ODBC Driver returns an error telling me it requires a number of parameters.
>
> Any ideas on how to get around this
>