There are any number of approaches. Too suggest a reasonably efficient route
would require some knowledge of:

1) Your proficiency with VBA
2) the type of file (CSV, fixed width, tab delimited, etc) and its size (#
of lines)
3) whether you need to be able to use multiple text files or if it is always
going to be the same file name and in the same location.

Beyond that, you treat the file as a textstream object, use the Readline
method to iterate through each line in the file, parse each line using the
split method (assuming it is delimited), put the parsed values into cells

While not a difficult task, it isn't trivial for a VBA novice.

"Dan" wrote:

That is exactly what I am trying to achieve. Any input on how the code should
look is appreciated.

"Duke Carey" wrote:

You can accomplish what you want by writing VBA code, or by manually changing
the data layout after it has been imported.

"Dan" wrote:

How can I limit the number of lines when importing a file? Limit the import
to the first 53 lines of a file that has 50,000+ lines.

Want to import the first "XX" set of lines, then I want to skip a set of
lines, then continue to import the rest of the lines. The second import needs
to be inserted 2 or 3 lines down from the first import.

There is the function:

Workbooks.OpenText Filename:=

But it only has a StartRow and can not specify the "EndRow". Also can not
specify where to start in the worksheet, i.e. Cell A5

Thanks