Microsoft KB Archive/134684

= Some ODBC Drivers Do Not Support Delete =

Article ID: 134684

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q134684



SUMMARY
In Microsoft Query, you cannot delete database records if you are using the ODBC drivers designed to access the following file formats:

  Microsoft Excel Text files

If you attempt to delete records from a file in either of these formats, you may receive the error message:

Feature not available



MORE INFORMATION
Microsoft Excel can use ODBC drivers to execute SQL queries on an external database. Using this capability, it is possible to perform actions on a database, such as Insert records, Update records, and Delete records.

The ODBC drivers shipped by Microsoft are all capable of performing the above operations, with the following exceptions:

  Microsoft Excel ODBC driver - no Delete Microsoft Text ODBC driver - no Delete

Additional query words: MSQuery

Keywords: kbinterop KB134684

-

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

© Microsoft Corporation. All rights reserved.