Article ID: 108190
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Query 2000
This article was previously published under Q108190
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.
You may also receive the following error message:
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.
Additional query words: MSQuery
Keywords: KB108190