Answered my own question:
Just in case anyone is curious how I did this...

Noticed that if you rename the ***.txt to ***.cvs it will put in XLS
format
Took txt file in batch file and renamed. Used the new spread sheet
name in place of
Sheet2 and the whole column. Placed this is a folder on the server and
just attached
a short cut to desktop and used link to batch file to run inside excel
to update each time.

=IF(COUNTIF(ExTRTbl.csv!$A:$A,C8)0,"Yes","No")

This was my fast work around... but if anyone else knows of a better
way? Please post.