I have created one program based on DTS which will upload the excel file in SQL Server. I am searching from couple of days to check the column name heading.
If user has missed any column system should show the message "Columns are not matching" please help
Dim extension As String = System.IO.Path.GetExtension(File_Upload.PostedFile.FileName)If extension <> ".xls" Then
File_Upload.SaveAs(Server.MapPath("Load_Master") & " \ R1825_FR_MACESS_FILE.xls")
View Complete Post