import delimited text file into mulitple excel sheets

[debby s]

How do you import a delimited text file (about 150,000 lines) int
mulitple excel worksheets. My excel sheet is limited to 65,000 lines

 

[Frank Kabel]

Hi
you may have a look at the following macro
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596

though written for Excel 95 the changes for Excel97+ are indicated