XL7: Data Access Object Doesn't Install Lotus ISAM Driver

ID: Q132218

7.00 WINDOWS public

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

When you use the OpenDatabase method to access a Lotus database, you may receive the error:

   Run-time Error 3170:
   Couldn't Find installable ISAM

CAUSE

Microsoft Excel 7.0 includes the Data Access Object (DAO) for Visual Basic to allow you to access external databases. However, this DAO does not include the Lotus ISAM driver.

Note that Data Access Object Help may be misleading because it contains an "Accessing Data in a Lotus Spreadsheet with DAO" topic.

WORKAROUND

If you need to use a Lotus database with DAO, first open the Lotus file in Microsoft Excel and then save the file in the Microsoft Excel format.

MORE INFORMATION

The DAO Help file is shared among other Microsoft application, some of which may install a Lotus ISAM driver.. However, you do not need to install a Lotus ISAM driver to use Lotus data in Microsoft Excel.

Lotus 1-2-3 is manufactured by Lotus Corp., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this products' performance or reliability.

KBCategory: kbinterop KBSubcatagory:

Additional reference words: 7.00 WKS WK1 WK3

Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997