这样的文本文件如何读入数据库?


                              管辖机构：  4012345     报表编号  :C0000001       
                                   扣款通知书                                   
  机构：  4000000xx支行     $w                                  页号：    1  
 ------------------------------------------------------------------------------ 
                                                                                
                    xx支行     $w                                             
                                                日期：      2002-01-01          
                                                                                
邮编  :  123456                                                                 
地址  : 九龙路６３弄１０号１０１室                                  
姓名  : 郑一                                                                  
                                                                                
                                                                                
                              xx银行消费信贷扣款通知书                        
                                            扣款日期：  2002-01-01              
                                                                                
尊敬的  郑一                                    先生／女士  :                   
    我行已从您的帐户中支取以下金额作为本次供款额，  特此通知。                  
 ------------------------------------------------------------------------------ 
贷款帐号  : 400000000000000001                        客户编号  : 00000001      
楼盘名称  : xxxx建设发展有限公司                      楼盘编号  : 000001        
存款帐号  : 4000000000001234567                       　总期数  :  180          
现用利率  : 0.00465000                                罚息利率  : 0.00630000    
                                                                                
期号                本金                 利息                 罚息  起息日期    
 ------------------------------------------------------------------------------ 
  20             4,670.04             5,185.98                 0.00  2002-01-11 
                                                                                
本次扣款金额为  :               9,856.02                                        
阁下现时在我行的贷款余额为  :                   1,110,594.20                    
 ------------------------------------------------------------------------------ 
说明：如有不符，请于扣款后２０天内到经办  银行查询  ,过期则视阁下已认可。  
                        ...........
                        ...........
                        ...........
                        ...........
                        ...........
                        ...........
                                                                                
                              管辖机构：  4012345     报表编号  :C0000001       
                                   扣款通知书                                   
  机构：  4000000xx支行     $w                                  页号：    2  
 ------------------------------------------------------------------------------ 
                                                                                
                    xx支行     $w                                             
                                                日期：      2002-01-01          
                                                                                
邮编  :  123456                                                                 
地址  : 八龙路２６３弄１号１１０１室                                  
姓名  : 郑一                                                                  
                                                                                
                                                                                
                              xx银行消费信贷扣款通知书                        
                                            扣款日期：  2002-01-01              
                                                                                
尊敬的  王小一                                  先生／女士  :                   
    我行已从您的帐户中支取以下金额作为本次供款额，  特此通知。                  
 ------------------------------------------------------------------------------ 
贷款帐号  : 400000000000000002                        客户编号  : 00000007      
楼盘名称  : xxxx建设发展有限公司                      楼盘编号  : 000002        
存款帐号  : 4000000000002222227                       　总期数  :  180          
现用利率  : 0.00465000                                罚息利率  : 0.00630000    
                                                                                
期号                本金                 利息                 罚息  起息日期    
 ------------------------------------------------------------------------------ 
   3               407.72             1,420.40                 1.00  2002-01-01 
                                                                                
本次扣款金额为  :               1,828.12                                        
阁下现时在我行的贷款余额为  :                     337,781.94                     
 ------------------------------------------------------------------------------ 
说明：如有不符，请于扣款后２０天内到经办  银行查询  ,过期则视阁下已认可。  
读入PARADOX数据库表为
XM     DKZH               LPBH               XYLL       BJ       LX        FX    RQ
郑一   400000000000000001 楼盘编号  : 000001  0.00465000 4,670.04 5,185.98  0.00  2002-01-01
                        ...........
                        ...........
                        ...........
                        ...........
                        ...........
                        ...........
王小一 400000000000000002 楼盘编号  : 000002  0.00465000 407.72   5,185.98  0.00  2002-01-01
这样的文本文件如何读入数据库?

解决方案 »

  1.   

    理解下面的三个函数：        copy()
            delete()
            pos()
    哪个银行的，可以把文本发来，我帮你写！
      

  2.   

    filehandle := FileOpen(inputfilelist.strings[FileId], fmOpenRead);
    fileread(filehandle, inputdatas[1], l);
    table1.fieldbyname('aa').asstring:=inputdatas;
      

  3.   

    做一个文本类型的数据库，
    ttASCII
    对刚才这个文本进行读取。
      

  4.   

    ...
    query.Sql.Add('Insert into TableName(DataField1,DataField2,...) Values(:p0,:p1,...)');
    query.Parameters[0].Value:=XX1.Text;
    query.Parameters[1].Value:=XX2.Text;
    ...