"AMM" wrote in message
...
When importing a .txt file with more than 4500 rows, anything above 4500
is
not imported. Is there a way to import the entire .txt file into one Excel
workhsheet?

In Excel, exactly what steps are you taking to begin the import process?

and:

What's the format of the text file? Columns separated by commas, spaces,
etc?