今天想要把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
ACCESS导入db2的数据
最新推荐文章于 2018-04-21 16:51:26 发布