请教报文导入数据库的问题
从来没做过报文导入数据库中一个表的问题,想请教做过的朋友能不能给指点一下,我知道大体上好象是一行行读,以:为分隔符,但是如何来写能不能写过的朋友粘一个出来给我看看,我的报文很简单
要提单号和箱号插入表中即可.报文是TXT文本的.数据库是sql2000的.
00:COSTCO:CONTAINER LOADING LIST:9:CNSDL:DCTDL:200701221549'
10:BPAM:XIN JIN ZHOU:2261S:CSCL:CHINA SHIPPING'
51:CSVDLHPA2489:CNGN2::CNDLC::::CNHUA:'
52:1:35:6:PK:26000.0:180.0::::'
53:酒糟蛋白饲料'
54:N/M'
56:CCLU6847910:45G1:F:O:200701121201:X33685:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6175353:45G1:F:O:200701121201:X33689:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6555950:45G1:F:O:200701121201:X33691:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6534659:45G1:F:O:200701121201:X33682:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6442980:45G1:F:O:200701121201:X33699:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:TGHU8616197:45G1:F:O:200701121201:X33680:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6329464:45G1:F:O:200701121201:X42676:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6583421:45G1:F:O:200701121201:X33693:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:TGHU8412953:45G1:F:O:200701121201:X42581:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6790645:45G1:F:O:200701121201:X42583:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6540944:45G1:F:O:200701121201:X33547:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6928014:45G1:F:O:200701121201:X33548:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6032856:45G1:F:O:200701121201:X33549:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6313154:45G1:F:O:200701121201:X42849:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:GLDU7237741:45G1:F:O:200701121201:X33696:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:GESU5124400:45G1:F:O:200701121201:X33697:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU5024460:42G1:F:O:200701121201:X33688:CSD:::::::1:3650.0:26000:60.0:CSD:'
56:TGHU8350044:45G1:F:O:200701121201:X33687:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6282602:45G1:F:O:200701121201:X33698:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6622847:45G1:F:O:200701121201:X33684:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU4549602:42G1:F:O:200701121201:X33542:CSD:::::::1:3650.0:26000:60.0:CSD:'
56:TRLU5730354:45G1:F:O:200701121201:X33541:CSD:::::::1:3890.0:26000:60.0:CSD:'
56:CCLU6369298:45G1:F:O:200701121201:X33690:CSD:::::::1:3890.0:26000:60.0:CSD:'
99:1'
报文大体就是这样的格式.