Hi All,

I have an aspx page that is used to upload an excel and read it to dataset. Everything is working fine on my local machine. But when i uplaod the page to Test Server, It throw an Unspecified Error when code tries to fill the dataset.
Code is as follow
                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=" & strFile & ";Extended Properties=""Excel 8.0;HDR=NO"""
                myConnection = New System.Data.OleDb.OleDbConnection(strConn)
                myAdapter = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", myConnection)
                myAdapter.Fill(myDataSet)

When code reaches to last line, It throw the error.

Kindly Help

Thanks in Advance

did you give read/write permissions for the iusr and aspnet accounts to that directory

Jason Hall

Yes,
I had given full permission to everyone.