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

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.
Lastnosti

ID članka: 132218 – Zadnji pregled: 14. feb. 2017 – Revizija: 1

Microsoft Excel 95 Standard Edition

Povratne informacije