MSQuery: Cannot Create Index with Text ODBC Data Source

 Last reviewed: September 13, 1996
Article ID: Q108190
The information in this article applies to:
  • Microsoft Query for Windows, versions 1.0
  • Microsoft Query for Windows 95, version 2.0
  • Microsoft Excel for Windows, version 5.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In the versions of Microsoft Query listed at the beginning of this article, when you save a query result to a text data source, you may receive one of the following error messages. The error message you receive depends on the version of the Text ODBC driver you are using. 

   Version of text
     ODBC driver     Error message
   ---------------   ---------------------------------------------------
        1.0          Create index statement not supported.
        2.0          Feature not available.
        3.0          Operation is not supported for this type of object.
You may also receive the following error message: 

   Unsupported SQL command statement.

CAUSE

Text data sources do not support the use of indexes. Therefore, when you attempt to create an index for a text data source, Microsoft Query displays the error messages described above.

RESOLUTION

To avoid receiving these errors, turn the Save Indexes option off in the Save As dialog box.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Even if you receive the error messages stated above, Microsoft Query continues to save the query result to the specified text file. However, no index is created for the file.

KBCategory: kbtool kbusage
KBSubcategory: xlquery

Additional reference words: 1.00 2.00 5.00 7.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.