Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.crashesgpfs,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
too few parameters
Microsoft Excel 2002 SP-2, Microsoft Windows XP professional
I have my queries written in MS Access, and I pull the results into Excel via 'import external data'...'New database query'. My queries run fine in Access, and it works ok for most of the stuff I pull into Excel, but sometimes when I try to pull the results in Excel, I get an error that says "too few parameters expected". The error occurs at the very last step in the 'get external data' procedure, as Excel tries to connect to the datasource. This seems to occur most often when I have a union query somewhere in my Access query chain. This is extremely frustrating as I have to figure out ways to rewrite my queries without the union query. Has anyone seen anything like this before? Does anyone know why a union query in Access would cause such an error in Excel? Anyone know why Excel does this or maybe even how to fix it? Thanks, -Lou Sanderson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a worksheet's print parameters to other worksheets? | Excel Worksheet Functions | |||
Excel Queries with subqueries and parameters | Excel Discussion (Misc queries) | |||
Calling Excel from Word with parameters | Excel Discussion (Misc queries) | |||
Help : Using Parameters with External Date Query | Excel Discussion (Misc queries) | |||
Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) |