Import Large Files (Excel 2002)

Hi

I would like to use the code below to import a large file into Excel however this code is for importing a .csv file and my file is a .txt file, is there anyway this code can be adapted to import a .txt file

Many Thanks

Braddy

Here is some code to import the data into an array, when the array is full, it dumps it to a new sheet and then continues. Theoretically you are only limited by memory.