By selecting just one cell, and choosing "Get detailed data" from right-click menu, re-sampling will take place at full resolution, i.e. no rows (or columns, if file is wide) is skipped when loading from file.
Note: The number of records loaded at full resolution is again confined to spreadsheet capacity, but this way you have access to a custom portion of the file instead of just the beginning.