I'm not sure whether that can be done, unless the text file was originally created by saving a table through excel as a text file.

You'll have to use code to read a text file. Something like this:
Code:
open textfile1.txt for input as #1