Ok, using Office XP, I'm trying to use the DataImport External DataNew
Database Query feature to bring data into my spreadsheet. I'm trying to use a
query located in example.mdb to do this.

Example.mdb contains nothing but link tables, but I am able to run my query
in Access just fine. When I select example.mdb as my external data source,
choose one of the queries located therein, and click 'Finish', I get the
following error message:

"Too few parameters. Expected 1."

....Then the import process dies and I'm left staring at a blank spreadsheet.

What is causing this? I've imported data this way before with no problems.

Is your query a parametric query. That is does the query prompt you for a
condition under which the query will run, at run time. If so you will get
this error as I assume Excel is not set up to provide that answer.

"simsjr" wrote:

Ok, using Office XP, I'm trying to use the DataImport External DataNew
Database Query feature to bring data into my spreadsheet. I'm trying to use a
query located in example.mdb to do this.

Example.mdb contains nothing but link tables, but I am able to run my query
in Access just fine. When I select example.mdb as my external data source,
choose one of the queries located therein, and click 'Finish', I get the
following error message:

"Too few parameters. Expected 1."

...Then the import process dies and I'm left staring at a blank spreadsheet.

What is causing this? I've imported data this way before with no problems.

Ah, maybe it's because I set two fields as search variables, asking a user
for input (ie, 'EmployeeID' and 'Date').

"Jim Thomlinson" wrote:

Is your query a parametric query. That is does the query prompt you for a
condition under which the query will run, at run time. If so you will get
this error as I assume Excel is not set up to provide that answer.

"simsjr" wrote:

Ok, using Office XP, I'm trying to use the DataImport External DataNew
Database Query feature to bring data into my spreadsheet. I'm trying to use a
query located in example.mdb to do this.

Example.mdb contains nothing but link tables, but I am able to run my query
in Access just fine. When I select example.mdb as my external data source,
choose one of the queries located therein, and click 'Finish', I get the
following error message:

"Too few parameters. Expected 1."

...Then the import process dies and I'm left staring at a blank spreadsheet.

What is causing this? I've imported data this way before with no problems.