银行对账单的引入实例UFIDA-CC-78引言软件提供银行对账单的引入功能，目前提供文本文件、DBF文件和MDF文件三种类型。在引入之前需要进行引入模板的建立，一般来说设置好后就可以引入了。但是可能会在操作的过程中出现一些问题。下面就结合实例操作一下。首先先看一份银行提供的对帐单，格式是.XLS[HISTORYDETAIL]凭证号本方账号对方账号交易时间借/贷借方发生额贷方发生额0020000140901442465602000014114000012822006-3-116:15贷400,000.0010355108020000140901442465602000493092010022952006-3-116:02借1,240.00002000014090144246562006-3-114:23贷561,264.2710355093020000140901442465602000045090144147172006-3-114:16借11,500.0010355100020000140901442465602000223090144177762006-3-111:11借35,000.0010355078020000140901442465602000029090890068402006-3-110:56借45,000.00002000014090144246564102006-3-110:19借240.31035509602000014090144246564102006-3-110:15借6,830.001035510902000014090144246564110602000101490407802006-3-110:11借2,053.501035509802000014090144246564102006-3-110:02借3,000.0038481802000014090144246562006-3-19:49借80,000.001035508702000014090144246562006-3-19:47借207,118.6938483102000014090144246562006-3-19:08借30,000.0010355125020000140901442465602000492090248407312006-3-216:13借2,680.0010355094020000140901442465602000042090881104132006-3-214:53借6,400.001035508102000014090144246564102006-3-211:22借4,710.00002000014090144246564102006-3-211:17借88,014.440020000140901442465602000968115000072152006-3-210:49借301035506802000014090144246564102006-3-210:48借1,300.001035511402000014090144246564102006-3-210:36借2,150.00建立模板文件由于在建立引入模板时需要指定模板文件，所以需要先建立一个模板文件。这里我们以MDB文件格式为例：需要先生成所需字段的XLS文件，凭证号交易时间借方发生额贷方发生额2006-3-114:312598552006-3-114:15570,000.002006-3-114:1441,465.572006-3-114:1334,889.3998562006-3-114:1335,400.002006-3-114:111,920.002006-3-114:102,146.9098452006-3-113:5416,570.0098462006-3-110:077,750.0098442006-3-19:194,950.002006-3-216:0030,416.432006-3-216:001,548.0098522006-3-215:521,479.002006-3-214:5210,440.0098512006-3-213:491,500.0098532006-3-29:1990,000.0098632006-3-313:522,640.0098542006-3-313:511,140.0098582006-3-313:5198098492006-3-313:515,000.0098482006-3-39:223,600.00MDB文件的生成设置引入模板引入对账单出现问题谢谢大家！
