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

How to Import Formatted text as new Slides in PowerPoint 0
Import External Data Problem 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Importing Union Query 1
Union query 5
Dynamic Naming of Form Button 3
SUM in a UNION query 2
UNION QUERY.. 3

Top