Comparing data in 2 text files

[Ronanm]

I have written a piece of code that asks the user to open one text file and it loads it into an Excel sheet. Then asks for a second text file which it loads into another sheet. Then runs through the second sheet to find corresponding records and when it does it compares a column of data.

This works OK (a little slow maybe), but unfortunately the second file contains a little more than the Excel maximum 1,048,576 rows.

How hard is it to load the second text file into memory, say a dictionary and then do the comparrison. Any pointers?

Thanks...

 

[sandy666]

try PowerQuery (Get&Transform) : merge with InnerJoin