Hi,
I have an xls file which users add data to and then upload it into the sql database. The xls file has specific named header rows which need to be correct or the upload errors however, if it errors the file is left in the folder and I want it to be deleted.
I have added some code that checks the sheet name and deletes the file if it is incorrect but can't find out how to reference the 8 header rows on the spreadsheet. The header rows are named such as 'customer name'
I have placed the code I am using below and would appreciate some code to show if its possible, how to check the row header names are correct and if not delete the file and throw an error message.
Thanks.
Dim Sheetname1 As String = String.Empty
Dim objConn As OleDbConnection = Go to the complete details ...