Hello Friends,
I am retrieving Data from Excell sheet to my Datagrid in ASP.Net Page
The is given below.But It is giving an unspecified error.
Can anyone tell me the sloution.


string connection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\ExcelData.xls;Extended Properties=Excel 8.0";
            string connection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\Book2.xls";
            OleDbConnection con=new OleDbConnection(connection);
            OleDbDataAdapter da=new OleDbDataAdapter("select * from [Sheet1$]",con);
            DataSet ds=new DataSet();
            da.Fill(ds,"XLData");
            DataGrid1.DataSource=ds.Tables["XLData"].DefaultView;
            DataGrid1.DataBind();

rajkumar sharma

__________________
-------------------
rajkumar sharma
http://www.apnasaathi.blogspot.com

http://support.microsoft.com/?kbid=306572

Hi,

Please notice :
/********************************/
string connection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\ExcelData.xls;Extended Properties=Excel 8.0";
            string connection="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\Book2.xls";

/********************************/

The first connection string is more accurate than the second one [exctended properties] in case of Excel

Can you that this is not creating a problem for you. moreover same variable is being initialized twice in this code. I believe this should throw the compile time error.

Anubhav Kumar

Thanks anubhav ,
But I have written only one connection string and i had tried with both the given connection strings one by one but Error comes out which is

"Unspecified error" at adapters fill statement.

rajkumar sharma