You won't be able to put all the data on one sheet if you keep it in a single
block of three columns. Easiest thing to do is break the text file into
pieces less than 65536 lines long and import to separate sheets. This is
fairly easy to do in VBA. Let me know if you'd like more details.

bp



"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