HostingASPNet:What type of error have you received? How do you get the date from excel, have you used some MS Office ActiveX control? If yes, have you installed it on the server?
I have not used any activex Control
this is sample code
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/File/" & filepath) & "; Extended Properties=""Excel 8.0;"""
'Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filepath & "; Extended Properties=""Excel 8.0;"""
''You must use the $ after the object you reference in the spreadsheet
Dim Group_Data As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
Group_Data.TableMappings.Add("Table", "ExcelTest")
Group_Data.Fill(Group_Dataset)
From the dataset , we will retrieve the each row data and stored in database.
it has not show any error but page show like this.
Connection Interrupted
The connection to the server was reset while the page was loading.
The network link was interrupted while negotiating a connection. Please try again.
Any solution pls....,