Problem in Importing data from Excel (Urgent)
-
Hi I am using following code to Import data from Excel File in .NET 2005 DataSet myDataSet = new DataSet(); string strConn = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\test.xls;Jet OLEDB:Engine Type=5; Extended Properties=Excel 9.0"; OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter addapter = new OleDbDataAdapter(); addapter.SelectCommand = new OleDbCommand("Select * From Mercury$", conn); addapter.Fill(myDataSet); On Executing it is giving me Following error "Could not find installable ISAM." I am using Excel2003 installed on Windows 2000. Thanks in advance Abhi
-
Hi I am using following code to Import data from Excel File in .NET 2005 DataSet myDataSet = new DataSet(); string strConn = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\test.xls;Jet OLEDB:Engine Type=5; Extended Properties=Excel 9.0"; OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter addapter = new OleDbDataAdapter(); addapter.SelectCommand = new OleDbCommand("Select * From Mercury$", conn); addapter.Fill(myDataSet); On Executing it is giving me Following error "Could not find installable ISAM." I am using Excel2003 installed on Windows 2000. Thanks in advance Abhi
-
Hi I am using following code to Import data from Excel File in .NET 2005 DataSet myDataSet = new DataSet(); string strConn = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\test.xls;Jet OLEDB:Engine Type=5; Extended Properties=Excel 9.0"; OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter addapter = new OleDbDataAdapter(); addapter.SelectCommand = new OleDbCommand("Select * From Mercury$", conn); addapter.Fill(myDataSet); On Executing it is giving me Following error "Could not find installable ISAM." I am using Excel2003 installed on Windows 2000. Thanks in advance Abhi
You need to check proper registry entry of Msexcl40.dll. Please go through following link and follow the steps given. http://support.microsoft.com/kb/209805[^] Regards, Ketan