help,a difficult text how to sql table code ?   

help,a difficult text how to sql table   code  ?

i have a text as follow, line with ¡°|¡±and {LF},

8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|




i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate 
smalldatetime£¬update  smalldatetime£¬after to sql table is as follow,


sign           year          month             trandate    update
  8       -186075919.000        387820.000   3/31/2008  4/23/2001
  9            -3919.000       -123620.000   3/31/2008  1/1/2001
  8        -18623419.000        387820.000   5/30/2008  4/23/2001



could you help me how write the sql code ?

date: Sat, 5 Apr 2008 15:32:51 -0700   author:   agiler