Copying data( in text file) onto a table

[sudpat]

Hi,

I have to transfer a text file which have rows in a pattern as shown below:-

00000000234| 0003434343|Michael|Derosal|001020| | | |

"|" is the delimetor the last 3 delimiter's basically specify that last 3 columns are blank.

Which transfer protocol I can use( BCP etc) and how to use it since I have a delimiter "|" seperating each column.

Any help would be greatly appreciated.