Excel "Micorosft Query" from Access (Too Many Parameters)

D

Donica

• In Access I can enter a dynamic parameter that is read into a query
(sql statement) - - the parameter is usually in a form
page,
example “monthâ€
• I then utilize the Data tab in Excel – from other sources “Microsoft Queryâ€
• If I have a hard coded parameter it pulls data from Access just fine, but
if I have a dynamic parameter it refuses and says “too many
parameters
expected†–
• My question is – is there a work around?
 

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

Microsoft Query - pull data from Access "Too many parameters" 2
Create a status designation from 5 date fields using "Not IsNull" 10
Alternative for MS Excel VLOOKUP function in MS Access2003 4
via 2000 Access to retrievel data from 2000 outlook public folder 0
Too few parameters error with a IIF statement 5
Adding Sequential Numbers to a Query 1
Access Report on Parameter Query 3
Move from one file to another 1

Top