Hi, I have two Excel "book1.xlsx" and "book2.xlsx", book1.xlsx have 1,000,000 rows and 10 columns, book2.xlsx have 100,000 rows and 5 columns, I need to used two Excel match the data each other, but the data is too big, can not read a collection, it will out of memory.
I can not try to OLEDB...