Problem in Importing data from Excel (Urgent)

[Guest]

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\)]

http://msdn.microsoft.com/data/ref/mdac/downloads/

Jet SP 8 (bottom of page) - download for your platform.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[sloan]

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