Forum Discussion
Too large dataset - extract data within date range
Unfortunately that doesn't work on Step 1. Excel opens the file and show only first million of rows ignoring the rest, we have no access to extra records from the grid.
If the user is working with a data set of millions of rows that exceeds Excel's row limit, alternative methods would have to be used to extract the data within the specific date range.
One approach, as already mentioned by Mr. Riny_van_Eekelen , is PQ.
That would also be the best approach if the data set is to be created with Excel.
Other approaches such as Python or database management systems (DBMS) are far beyond my scope of knowledge.
However, if the data set does not exceed Excel's row limit, it would be a possible alternative, not the most elegant as PQ, but theoreticaly it would be an alternative :).