Beginner:: Parsing a text file into a temp table

[tke]

I am trying to open a text file and parse it into a temptable on a database. The file has delimeters in it. Thanks for the help.

EXAMPLE OF TEXT IN TEXT FILE:

REF*87*X096
ZAP*R0103*9
ZAP*R0104*INFO34