文本数据中一条数据分为多行时不能正常恢复的问题!理想状态是每条数据在TEXT文本中占用一行,恢复数据一切OK,但有时一条数据占用多行,改如何办呢?
哪位高手给点源代码?谢谢谢谢!!!!!!!!(数据库为SQL SERVER 2000)文本数据如下:
#2003,6,by,分公司A,部门费用
,www,0,343424,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,44444,0,0,0,22,2342,-2364,
#2003,6,by,分公司A,其他人员,www,2,23423,5,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,23432,-23434,
#2003,6,by,分公司,小王,www,1,342,34,2,0,0,234,0,0,0,0,0,0,0,0,0,0,0,0,0,0,236,34,-270,
#2003,6,by,分公司A,小计,,3,367189,72,26,0,0,234,0,0,0,0,0,0,0,0,0,0,0,0,0,0,260,25808,-26068,
#2003,6,zy,分公司A,部门费用,wrrr,0,3423,42,3,0,0,0,0,0,0,0,0,0,0,0,22,0,0,0,0,0,25,234,-259,
#2003,6,zy,分公司A,小计,,3,3423,42,3,0,0,0,0,0,0,0,0,0,0,0,22,0,0,0,0,0,25,234,-259,
#2003,7,by,分公司A,部门费用,www,0,1000,32,3,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7,100,-107,其中“#”标注为每一笔数据,每笔数据均为30个字段!