Is there a way to create a pivot tabel where the source data is a text file with more than 65000 rows of data? Normnally I just import the text file to excel and then create a pivot, but in this case I have too many rows but don't want to lose data.

I guess I can use the create pivot tabel from external data source function but could somone take me through the steps to do this from a large text file - if this is possible!

Many Thanks.