Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

"Could not find installable ISAM" error when you refresh a data table in Excel


View products that this article applies to.

Symptoms

When you try to refresh data in a Microsoft Excel workbook that links to a Microsoft Access database, you may receive the following error message: 

Could not find installable ISAM

This issue occurs if the workbook was previously opened and refreshed in a newer version of Excel.

↑ Back to the top


Cause

When an Excel workbook that's linked to an Access database is opened in a later version of Excel, parameters may be added to the connection string. If the earlier version of Excel does not recognize these parameters, it triggers the error message.

↑ Back to the top


Resolution

To resolve this issue, delete the new parameters from the connection string. To do this, follow these steps:
  1. Open the Excel workbook.
  2. On the Data ribbon, click the Connections button.
  3. In the Workbook Connections dialog box, select the connection to the Access database, and then click Properties.
  4. In the Connection Properties dialog box, click the Definition tab.
  5. Delete the following parameters from the connection string:
    Jet OLEDB:Bypass UserInfo Validation=False;
    Jet OLEDB:Limited DB Caching=False;
    Jet OLEDB:Bypass ChoiceField Validation=False
  6. In the Connection Properties dialog box, click OK. At this point your data should be refreshed.
  7. In the Workbook Connections dialog box, click Close, and then save the updated workbook.

↑ Back to the top


More Information

If you refresh and save the workbook in a newer version of Excel, the issue will recur.

↑ Back to the top


Keywords: kb, kbexpertiseinter, kbtshoot, kbsurveynew

↑ Back to the top

Article Info
Article ID : 3041386
Revision : 3
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 298