Skip to main content

Posts

Showing posts from February, 2010

Error: Could not find installable ISAM

If you are getting error: "Could not find installable ISAM" while you are trying to connect to Excel file using Microsoft Jet OLEDb provider, here are are some possible solutions 1. Check the connection string. This is the most common cause. To connect to Excel file, you have to specify Extended properties in a connection string. The following connection string in a C# rogrram. string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\""; Pay attention to the double inverted commas " for Extended Properties value. If these are missing, you will get above error. Please note becuase " are part of the string you need to use escape character \ for C# for " for VB. 2. If above doesn't solve the problem, try Help -> Detect & Repair in Excel. 3. If you still have problem, try Microsoft solution http://support.microsoft.com/kb/209805 If this doesn't solve t