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!

On Mon, 09 Jul 2007 08:30:10 -0700, tyler.deutsch@gmail.com wrote:

>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]