ACCESS导入db2的数据

今天想要把db2种的数据导入到access中，试了下还真的是行了哈哈，下面说下过程：
1。系统中要建立db2的数据库，我本机的数据库别名是hrebd
2. 打开控制面板--〉管理工具--〉数据源 配置db2的数据源，如图 图片1.bmp
3。打开Acess数据库，点击导入--〉文件类型选择odbc,如图片2.bmp,选择机器数据源，然后选择表就可以了。

还是参考这个，这个更详细 http://www.ibm.com/developerworks/cn/db2/library/techarticles/dm-0605bhogal/

同样的，如果你需要把access数据库中的数据导入到db2种，你只需要建立和access中表结构一样的表
如我建立的表结构是：
 create table test(
   id integer,
   student_no varchar(100),
   desk_no varchar(100),
   subject varchar(100),
   edu  decimal(22,2) default 0,
   psy decimal(22,2) default 0,
   field6 decimal(22,2) default 0,
   sum_score decimal(22,2) default 0
 );

然后从access数据库中导入数据到文件，后缀名用.del格式就行了。
可以看我上传福建对应的格式，注意：
数据的列数要和表结构的列数一样
如果为数字型的话不用加引号，参考文件格式吧


不能上传附件，随便贴点数据

2,"083032100003","0321000102","语文",49,59,55,109
3,"083032100013","0321000103","语文",71,56,58,121
4,"083032100007","0321000104","语文",73,73,64,137
5,"083032100009","0321000105","语文",63,75,51,120
6,"083032100005","0321000106","语文",75,67,62,133
7,"083032100001","0321000107","语文",72,72,54,126
8,"083032100010","0321000108","语文",62,59,54,114
9,"083032100004","0321000109","语文",55,65,59,119
10,"083032100002","0321000110","语文",62,59,53,11
11,"083032100006","0321000111","语文",58,55,53,10
12,"083032100008","0321000112","语文",67,58,56,11
13,"083032100011","0321000113","语文",53,52,59,11
14,"083032100023","0321000201","语文",61,77,57,12
15,"083032100054","0321000202","语文",52,87,57,12
16,"083032100037","0321000203","语文",73,68,54,12
17,"083032100053","0321000204","语文",77,49,50,11
18,"083032100042","0321000205","语文",80,78,53,13
19,"083032100016","0321000206","语文",70,61,54,11