HI I HAVE TO READ SOURCE FILE THAT CONTAINS E7001 26/05/11 Tickets du : 26/05/11 aaaa 2,00 39,00 a1 01 SS bbbb 7,00 15,00 b2 01 SS E7002 02/04/11 Tickets du : 26/05/11 dddd 2,00 39,00 d1 01 PS cccc 7,00 15,00 c2 01 PN i would like to get aN OUTPUT FILE csv or table schema contains the data 7001 26/05/11 aaaa 2,00 39,00 a1 01 SS 7001 26/05/11 bbbb 7,00 15,00 b2 01 SS 7002 02/04/11 dddd 2,00 39,00 d1 01 PS 7002 02/04/11 cccc 7,00 15,00 c2 01 PN thanks for help best regard MerouanBest Regard Merouen

You should read John Welch's blog on importing flat files with multiple row types. Talk to me now on