Compare two Excel tables

Help
, ,
2

Hi @rlwalters,

  1. Read the two xl sheet in two different datatable.
    2.Keep a do while loop with column index.
    3.Inside Loop check the tbl1.Columns(intCol).ColumnName = tbl2.Columns(intCol).ColumnName
    4.add string array the difference colum Name.

Regards
Balamurugan

1 Like