Too few parameters. Expected 2

S

Suzanne

I need to create a new database query in excel using a query I have in access
(I have MS Access 03 and MS Excel 03), I need this query to be linked to
access and display updated information at all times, so I go into excel to
import external data, new database query etc etc when I get to the last step
it gives me an error saying "Too few parameters. Expected 2". I don't know
why it's giving me this error, can anyone help?
 
F

FSt1

hi
are you using an access query as the data source?
does the query have prompts for parameters?
this is usually were this happens.
if so, you must more the prompts to the excel side.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too few parameters 2
Import New Database Query (Union Query) in Spreadsheet 2
Too few parameters error with a IIF statement 5
too few parameters 5 expected 2
Run-time error 3061. Too Few Parameters. Expected 2. 2
Renaming columns in MS Query 2
Excel Query setup 0
Too few parameters exporting to text 14

Top