Querying Access database

J

James

I have an Excel query that is based off of a union query
in Access. I keep getting the error "Too few parameters",
even though I can't find anything wrong with the query.
The only problem seems to be that the data source is a
union query instead of a select query. Any suggestions?
Thanks.
 
M

Mike A

If you click on the SQL button in the MS Query window, you can view &
edit the SQL statement directly.

If you have a working query in access, open the database, go to the
query you want, and the query editor will also have a SQL button. You
can copy the SQL statement from Access to MS Query. Then close
Access, go back to MS Query, and return the data to Excel.

Let me know if this works or not; we can fix it!




Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 

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

Import New Database Query (Union Query) in Spreadsheet 2
Importing Union Query 1
SQL Union in MS Excel 2007 1
Access query not showing as sources for pivot table 2
Access #Error & Excel Pivot 0
Too few parameters 2
ComboBox RowSource UnionQuery 1
Am I disturbing a machine in production floor if I access its database remotely? 4

Top