Microsoft KB Archive/831592

= Cannot change the data type in a Parameter Query in Microsoft Query =

Article ID: 831592

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Query 2000

-



SYMPTOMS
In Microsoft Excel, you try to change the data type in a Parameter Query in Microsoft Query. When you do this, the Data type list box is not available.



CAUSE
This behavior is a design change in Microsoft Query. The Data type list box is unavailable (turned off) when the database driver supports the SQLDescribeParam command. This behavior does not occur when you use Microsoft Query with a Microsoft Access database.

Keywords: kbexpertisebeginner kbprb KB831592

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.