I usually just open the text file, then copy the data to the location where
I want it and close the text file without saving.

How are you importing the files? If you are using recorded code, then I
suspect you are overwriting the first file.

Regards,
Tom Ogilvy

tina SPEILBERG wrote in message
om...
How to import more than one text file into Excel ?

I am trying to combine a few text files into one Excel file.

When I import the second text file the first one disappears..what
happens to the first file ?

Please let me know.