Import up-to-n-rows from text
<p>When importing from text to Excel, I have seen many tips to overcome Excel's limit. My problem is different, I want to set a (small) limit myself, because what I want is to <strong>preview</strong> the data in some huge files. Therefore I need to ask Excel to import the data <em>up to some number of rows</em> (say 100 rows, or eventually setting any other limit, such as total count of bytes to read from the input file, or total cell count, anything).</p>

<p>I know a way to create a query connection that drops some <em>columns</em>, but what I want is a way to truncate while preserving all the columns.</p>

<p>Besides, VBA is not an option. I repeat the operation many times with different files and formats, I just need a handy trick to preview quickly with Excel using "Import From Text".</p>

<p>Any tips? Thanks is advance.</p>