Import New Database Query (Union Query) in Spreadsheet

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
 
A

alexrs2k

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
UNION QUERY.. 3
SQL Union in MS Excel 2007 1
Union query 5
Union query 5
Keep name of source query in Union 2
BUILDING UNION QUERY 9
SUM in a UNION query 2

Top