Import New Database Query (Union Query) in Spreadsheet

  • Thread starter Thread starter klock
  • Start date Start date
K

klock

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
 
Instead of pulling the parameters in Access , you should create them in Excel
Microsoft Query.
 

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

Importing Union Query 1
SQL Union in MS Excel 2007 1
UNION QUERY.. 3
Union Query Where Clause 0
Union query 5
Union Queries - Record Formatting 1
I can't run the paramters I need in Microsoft Query 1
Querying Access database 1

Back
Top