Hi OBP, sorry to reply so late because was very busy recently.
Are you saying that to copy all the fields fm the text file into one cell in Excel?
Currently I am manually importing the text file into 2 worksheet via Excel. However i would prefer to auto import the text file via Access because i have all my reporting/ programming is in the Access file. tks.