Article ID: 170290
Article Last Modified on 5/21/2001
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Query 2000
This article was previously published under Q170290
SYMPTOMS
When you run a parameter query, one of the following error messages appears.
In Microsoft Query
Returning Data to Microsoft Excel
In both cases, no data is returned.
CAUSE
In Microsoft Query
This problem occurs when you do the following:
- You run a query against a SQL server. -and-
- The fields in the query use any of the following data types:
Decimal
Numeric-and-
- The value you enter for the parameter is greater than 32,767 or less than -32,768.
In Microsoft Excel
This problem occurs when you do the following:
- You return data from a SQL server and you use multiple parameter queries. -and-
- The parameters are fields of different data types.
WORKAROUND
If the field type is integer (numeric), limit data to only integer values between -32,768 and 32,767. For more information about field types, see the table in the "More Information" section in this article.
If you use multiple parameters and return data to Microsoft Excel, change the order of the parameter queries. Place the parameter that refers to a numeric field first.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
Data types are limited in the values they can store. The data type, storage size, and range limit for each type are listed in the following table.
Data type Storage size Range limit ----------------------------------------------------------------- Numeric 2 bytes -32,768 through 32,767 (integer) Currency 8 bytes -922,337,203,685,477.5808 through 922,337,203,685,477.5807 Decimal 14 bytes +/-79,228,162,514,,264,337,593,950,335 through +/-7.9228162514264337593543950335
For more information about parameter queries, click the Index tab in Help, type the following text
parameter
and then double-click the selected text to go to the "Create a query that prompts for criteria" topic.
Additional query words: XL97 msquery prompt
Keywords: kberrmsg kbprb KB170290