Querying Access database

  • Thread starter Thread starter James
  • Start date Start date
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.
 
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
 
Back
Top