Could not find installable ISAM ??

[MJB3K]

Hi, I keep getting this error "Could not find installable ISAM".

What is this error?

        /// <summary>
        /// Returns a data set of the excel information
        /// </summary>
        /// <returns>DataSet</returns>
        public static DataSet GetExcelInformation()
        {
            // create connection string
            string sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source=" + @"test.xls" + ";" +
                "Extended Properties=Excel 8.0; IMEX=1;"; // HDR = YES; "; // IMEX=1;";

            // create a connection to the excel xls
            OleDbConnection objConn = new OleDbConnection(sConnectionString);

            try
            {
                objConn.Open();
            }
            catch (OleDbException exc)
            {
                System.Windows.Forms.MessageBox.Show(exc.Message);

                return null;
            }
...

It catches the error in the try / catch block.

Any ideas??

Regards,

Martin

Computing Design And Services:

http://www.webrevolt.biz

 

[Kalisto]

The error generally means it cannot find the appropriate driver to read the data.

What version of excel are you using?

(some solutions to this are here..