Excel 2002 SP-2
Windows XP Professional SP-2

Does anyone know just what the 'too few parameters' error is in getting
external data (I get all my external data from MS Access)?

Sometimes I see this error when I have renamed my fields in Acces or if I
have a parameter query or something like that, and rightfully so. But
sometimes I get this error and I can find no reason why - the query runs fine
and the field names havent changed. I used to think it was more 'complicated'
queries in Access (i.e. union queries, left joins, etc.), but now excel is
acting up on a simple select query. I dont get this 'too few parameters'
error....

-Lou Sanderson

You will get this error if you misspell an Access field name in
your query. Ensure that everything is spelled properly.


"lou sanderson" wrote in
message
...
Excel 2002 SP-2
Windows XP Professional SP-2

Does anyone know just what the 'too few parameters' error is in
getting
external data (I get all my external data from MS Access)?

Sometimes I see this error when I have renamed my fields in
Acces or if I
have a parameter query or something like that, and rightfully
so. But
sometimes I get this error and I can find no reason why - the
query runs fine
and the field names havent changed. I used to think it was more
'complicated'
queries in Access (i.e. union queries, left joins, etc.), but
now excel is
acting up on a simple select query. I dont get this 'too few
parameters'
error....

-Lou Sanderson