If you are using MS Query then you can take the SQL statement from the MS
Query and put into the Excel query. When you use the menu from Excel: Data
- Import External Data - New Database Query the last menu that says FINISH
has an option to edit the query. If you select the edit option it opens MS
Query and allow you to view/modify the SQL.

When I program a VBA Excel query I usually start by recording a macro and
then maually edit the results of the macro and put it into a larger macro.
You can do the same thing and modify the SQL statment in the Excel Query as
needed.

"Marc T" wrote:

Hi all,

I have an Access Database which combines data from an external source
(Oracle based) with it's own data. Within the database is a query which
prompts for input such as 'choose week'. I need to run this query and
manipulate the data in Excel.... is there any way to pass the 'week'
parameter from Excel as can be done when doing a simple query via MS query? I
have tried a few ways but keep getting a Parameter Expected error.

I suppose the problem is trying to pass the parameter from Excel to MS
Query, and then on to Access.

Any advice most appreciated!
Marc