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

Debug Guru

Comments

Searching Unicode characters in Oracle table

Oracle implementation of Regular expression has no support for using hexadecimal code to search for Unicode characters. The only way to search for Unicode character is it use the character itself. Normally with Regular expression, you can use \x or \u followed by hexadecimal code to search for any character. E.g. \x20 will match space. But REGEXP_LIKE in Oracle does not support \x. You need to use unistr function to convert the code to equivalent character and then use it with REGEXP_LIKE. E.g. REGEXP_LIKE(source,'[' ||unistr('\0020')|| ']');

Why there is semicolon at the start of a JavaScript function?

Very often while reviewing the code for my team, I will come across a semicolon at the start of JavaScript function as show below ; (function () { 'use strict'; ...and I often wondered what purpose it served. Guess what. It is an insurance to make sure your script works fine when all other scripts are merged together; The leading ; in front of immediately-invoked function expressions (iffe) is there to prevent errors when appending the file during concatenation to a file containing an expression not properly terminated with a ;. So there you go. Now you know what that little semicolon is doing there in your code.

C# Performance Improvement - The Power of StringBuilder

Often when we are wring code we don't think about performance and go with the default options available to achieve a task. String concatenation is one such scenario. If you are doing simple and few string catenations, then you can use the following result = string1 + string2; string1+= string2; result = String.Concat(string1,string2); String.Format and string interpolation are few other options. However when you are performing large and repetitive operation, string catenation can be expensive. Here is an example to prove the point. As you can see it took 41 seconds to perform 100k string catenation. Now lets replace this with StringBuilder and see. 8 ms!!!!!! That is a massive performance difference. Hope you get the point. More info on StringBuilder can be found here https://learn.microsoft.com/en-us/dotnet/api/system.text.stringbuilder?view=net-7.0

Developing modern applications in cloud

Search This Blog