ODBC Problem

[RobMc]

Hi

I'm using Microsoft Query to get data from a MS Access database into MS Excel. It seems that whenever I pull data from a UNION QUERY or SELECT QUERY based on a UNION QUERY I get an error message:

"Too few parameters...expected 8"

Can anyone offer suggestions?

Thanks

 

[neileg]

My guess is that you have 8 underlying queries in the UNION. Normally, you would use a form to capture the parameter in Access so you don't have to provide the parameter 8 times.

Union queries can be an indicator of an un-normalised database. Perhaps you have a design problem you need to correct.

Of course I may be talking utter rubbish, because I would alwyas prefer to push data from Access to Excel rather that pull it as you are doing and so my experience with MSQuery is low.