Microsoft KB Archive/132218

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

PSS ID Number: 132218

Article Last Modified on 3/21/2001

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q132218







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.

Additional query words: WKS WK1 WK3

Keywords: KB132218

Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch

-

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

© 2004 Microsoft Corporation. All rights reserved.