Instead of pulling the parameters in Access , you should create them in Excel
Microsoft Query.
--
Alex
*Remember to click "yes" if this post helped you. Thank you!



"klock" wrote:

I have been using Import New Databse Query to update information from Access
to Excel. It works great for all table queries except Union Queries. I get
the error - "Too few parameters. Expected 1." How can I get around this with
still using a Union Query?

Thanks for any feedback