I have a csv file that I am loading into a datatable to process. Before processing, I want to verify the column headers against a template I will have stored. I see lots of ways for comparing Excel files / datatables but I just want to verify the headers of the incoming csv first to make sure nothin…

No u dont need to loop u can simply compare them with this dt1.Columns(0).ToString=dt2.Columns(0).ToString

Comparing Column Headers

Divyashreem (Divyashree Muddagangaiah) February 23, 2020, 6:35pm 9

You world read both tables and then You can write a simple stored procedure to execute as in below:

Topic		Replies	Views
Compare two Excel tables Help datatable , excel , activities	5	2123	May 15, 2018
Compare 2 datatable Headers to get matched columns from Datatable 2 Help datatable , excel , activities	12	1691	August 4, 2020
How to validate headers of an excel file (.xlsx), if they are correct or not? Studio	3	3147	May 23, 2020
Comparing two excel file Help excel	3	3053	March 22, 2018
Compare columns between two excel files and write values accordingly Studio	13	465	June 16, 2023