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)
When code reaches to last line, It throw the error.
Thanks in Advance