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.
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 the problem, beat you PC up with a stick and go for a walk.....
Debug Guru
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 the problem, beat you PC up with a stick and go for a walk.....
Debug Guru
Comments