when click on imagebutton import show this error('Items$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.)
my code :
If FileUpload1.HasFile Then
Try
Dim Path As String = String.Concat(Server.MapPath("~/Files/" + FileUpload1.FileName))
FileUpload1.SaveAs(Path)
Dim exlconn As String = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 8.0", Path)
Using oconn As OleDbConnection = New OleDbConnection(exlconn)
oconn.Open()
Dim dt As DataTable = oconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
Dim query As String = "select * from [Items$]"Go to the complete details ...