string strConn;
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
               

                "Data Source=C:\\abc.xls;" +
               

                " Extended Properties=Excel 8.0;";             
                OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);

                DataSet myDataSet = new DataSet();
                myCommand.Fill(myDataSet, "ExcelInfo");

                DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;
                DataGrid1.DataBind();
               

My Data Source file path is fixed. So, i want to define Excel file path in Data Source from asp:FileUpload selected path.

how can i do it in asp.net 2005. I can only get Excel file name.

winzone:

I can only get Excel file name.

You need to call FileUpload1.SaveAs(...) to save the file to the server.  If you have multiple simultaneous users, you will need to make sure the files do not overwrite each other.

The path the user has selected to upload the file is not useful....the server does not have access to the user's directory.

 Thank SGWellens ...