Two data table contains 1lakhs row data.I need to compare two data table and find out unmatched row

Help Activities
, ,
8

@Elancheran_E

This is how you can get excel as DB Using Excel As Database

then use a query to get the unmatched records


SELECT * FROM table1
EXCEPT
SELECT * FROM table2;

cheers