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