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
Cowboy (Gregory A. Beamer) - 04 Jul 2006 14:52 GMT
http://msdn.microsoft.com/data/ref/mdac/downloads/
Jet SP 8 (bottom of page) - download for your platform.

Signature
Gregory A. Beamer
*************************************************
Think Outside the Box!
*************************************************
> Hi
> I am using following code to Import data from Excel File in .NET 2005
[quoted text clipped - 20 lines]
>
> Abhi
sloan - 04 Jul 2006 16:37 GMT
9 times out of 10..... its your connection string.
Every space , quote and everything else has to be perfect. not "close", but
~~perfect.
Try alternate versions from
www.connectionstrings.com
> Hi
> I am using following code to Import data from Excel File in .NET 2005
[quoted text clipped - 20 lines]
>
> Abhi