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 :).
NikolinoDE But the OP clearly indicated that there were too many rows to display on the grid.
- For me, many is relative. Is it many in the range of possibilities of Excel or more?
Anyway it's just an alternative suggestion...nothing else.
Is it useful? I don't know it...should be decided by the user.NikolinoDE "Too many to be displayed" = "more than 1048576 rows". How 'relative' is that?
