The only way in Excel 2003 would be to import to multiple tabs. e.g. 40,000
records on one tab and 40,000 on another. The easiest way to do this is to
first import your data into Access. Then import your Access database into
Excel:

<Data
<Import External Data
<New Database Query
Choose "MS Access Database"

Then, from within the import wizard you can filter which records to import.
You can, for example, do 1 import filtering all "CalledNo" < 40000... then do
a second import filtering all "CalledNo" =40000.
--
Regards,
Dave


"Avadivelan TCS" wrote:

Hi All,
I am having a Text (.txt) file . It contains a record like this:

CalledNo CalledDuration Date
12354 04:50 10/10/2005
4789 12:30 12/25/2005
....etc.

that Text file contains more than 80,000 records. how can i import that data
from TEXT to EXCEL.
Thanks in advance