Compare csv file and Oracle table and highlight differences using Excel
I have a tab seperated csv file (abc.csv) as follows
Column 1 Column 2 Column 3
A 1 XX
B 2 YY
and a table (tblSample1)in Oracle
Tcol 1 Tcol2 Tcol3
A 1 XX
B 2 ZZ
I would like to compare column 2 and 3 and highlight the difference in
excel spreadsheet (which in this case is the following)
Column 1 Column 2 Column 3 Tcol 1 Tcol2 Tcol3
B 2 YY B 2 ZZ
What is the easiest way to compare the 2 and highlight the difference
using excel vba?
No comments:
Post a Comment