Importing Data from Access -- Parameter Errors

J

jwr

I am attempting to import a query from access. I get to the point of view
or saving query in excel and get message "Too few parameters, expected 4."

There are several parameters in my query.

How do I avoid this message and get my query into excel?
 
J

jwr

Yes the query works, but does ask for values of the parameters to be input.

I was using Microsoft query when I got "expected parameters".

Briefly - what I am attempting to do is --

I have an access database. I have a query and a report based upon that
query. I need to send via email the report for the end user to input
information into several "unprotected" fields and then have them email that
back to me. Access does not email reports in the same format so I have been
trying to find another way to get information emailed from access. Excel
template was my next try.

Thanks,
JR
 
Top