Article ID: 141174
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Query 2000
This article was previously published under Q141174
SUMMARY
In general, the specifications for Microsoft Query are limited by the ODBC drivers that are installed on your computer.
If you cannot tell the limitations of a particular driver by the documentation that comes with that driver, you can use ODBC Test (a programming tool for use with ODBC) to determine the driver's limits.
MORE INFORMATION
Characteristic Specification in MS Query
Maximum number of SQLGetInfo of SQL_MAX_TABLES_IN_SELECT tells the tables in a query driver's maximum. Maximum number of SQLGetInfo of SQL_MAX_COLUMNS_IN_SELECT tells the fields in a dynaset driver's maximum. A common limit is 255. For SQLServer, it's approximately 1310. Maximum dynaset size There is no set maximum; usually limited by the memory or hard disk space required to cache the values. There is a maximum row size, however, which is the maximum number of bytes in a single row (which may or may not include long values, as determined by a separate indicator). Maximum number of SQLGetInfo of SQL_MAX_COLUMNS_IN_ORDER_BY tells sorted fields in a the driver's maximum. query Maximum number of One, since Query doesn't allow you to build levels of nested nested queries. queries Maximum number of Query puts up to 255 characters in the cell. If characters in a cell you zoom on the field, you can get up to 32K of data in the Zoom dialog box. This is also governed by the definition of the data type. You can find out, for any given data type, the maximum number of characters by calling SQLGetTypeInfo for that type. For any given column, you can call SQLDescribeCol to find out the maximum number of characters that may be returned in that column. Maximum number of ANDs Neither Query nor ODBC restricts this, other than in a WHERE or HAVING the maximum length of a SQL statement (as below). clause Maximum number of Query allows up to 32K for the SQL statement that characters in an SQL it displays in the SQLdialog. The driver may have statement a limitation as returned by the SQL_MAX_STATEMENT_LEN value available through SQLGetInfo.
Additional query words: 5.00c XL5 XL7 MSQuery
Keywords: KB141174