Can you post some sample data from the text file, and the table structure from the table? This is a pretty easy process. I use Scripting.FileSystemObjects, however.
It also looks like you are having issues with the EMPLOYEE field being the PK field and duplicate values trying to be inserted. Is that that problem?
Please post more information and I will post some tested code.
Look it up at: http://wrox.books24x7.com