Too few parameters. Expected 1.

[Guest]

Ok, using Office XP, I'm trying to use the Data>Import External Data>New
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.

 

[Guest]

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.

 

[Jamie Collins]

Example.mdb contains nothing but link tables

When I select example.mdb as my external data source,
choose one of the queries located therein

Your statements are contradictory.

I get the
following error message:

"Too few parameters. Expected 1."

If you indeed have a MS Access Query object (i.e. a Jet VIEW or
PROCEDURE), you may have something in the SQL text that relies on the
MS Access UI i.e. cannot be used when called from outside of MS
Access. Post you Query object's SQL code.

Jamie.

--

 

[Guest]

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