XL: "Excel 7.0;" Is an Invalid Database Type in DAO

 Last reviewed: February 27, 1998
Article ID: Q141788
The information in this article applies to:
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel, when you use the OpenDatabase method or the Connect property, if you use "Excel 7.0;" for the database type, you may receive the following error message: 

   Run-time Error '3170'
   Couldn't find installable ISAM
Note that the Microsoft Excel 7.0 Help topic for the Connect property indicates that "Excel 7.0;" is a valid database type specifier. This information is incorrect.

WORKAROUND

To use data from a Microsoft Excel 7.0 workbook with Data Access Objects (DAO), use "Excel 5.0;" for the database type. For example: 

   Set DB = OpenDatabase ("C:\XL7FILE.XLS", False, False, "Excel 5.0;")
You can use "Excel 5.0;" for the database type for both Microsoft Excel 5.0 and 7.0 files because these versions share the same file format. Also, DAO uses the same installable ISAM to access both versions of Microsoft Excel.

To use data from a Microsoft Excel 97 workbook with DAO, use "Excel 97;" for the database type.

MORE INFORMATION

In Microsoft Excel, you can use DAO in a macro to access external data. When you use the OpenDatabase method or the Connect property, you provide a string that specifies information about the database.

For more information about the Connect property, click the Index tab in Microsoft Excel Help, type the following text 

   connect
and then double-click the selected text to go to the "Connect Property" topic.

In the "Connect Property" topic, in the table that shows possible database types and their corresponding database specifiers and paths for the Connect property setting, note that the table includes "Excel 7.0;" in the Specifier column of the table. This information is incorrect.

Additional query words: 7.00 8.00 97 XL97
Keywords : kberrmsg xlwin xldao
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbprb

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: February 27, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.