Pulling data into Excel "Too few Parameters"

[tyler.deutsch]

When I pull data from Access into excel using the external source
function, it always brings back an error message of "Too Few
Parameters. Expected 1."

How can I remedy this so that the data comes out?


Thanks!

 

[Guest]

One of two reasons:

Does your query in Access have parameters? if so remove them from the Access
query and put them directly in the MS Query tool that you use to pull the
data into Excel.

Or if not, there is a function in your query that isn't understood using the
MS Access->MS Query-> MS Excel route, the most common one i have found is the
NZ() function.

 

[John W. Vinson]

When I pull data from Access into excel using the external source
function, it always brings back an error message of "Too Few
Parameters. Expected 1."

How can I remedy this so that the data comes out?


Thanks!

Sounds like you're pulling the data from Access using a Query which has a
parameter that you're not filling in. Could you post your code, and the SQL
view of the query?

Another possibility is that your code has a misspelled fieldname - if your
table contains a field [PickledBeets] and you are trying to export a field
named [Pickled Beets], Access won't find it and will assume it's an undefined
parameter.

John W. Vinson [MVP]