求db2数据库中批量导出上万条的数据????
我想把这个数据批量的导入到excel中,有什么好的工具????或者解决方案????
[b]问题补充:[/b]
我试过aqua data studio这个工具,导出到excel中没有按照先是:表头,然后是:表中的数据,我要导出的数据是要按照表中的格式的,如果只是单纯的导出数据,我写sql就行了,
COM_ID,"TYPE_ID","TYPE_NAME","UPDATE_DATE","UPDATE_USER"
420000,"10000","财务费用","20080616","oadmin"
450000,"01","11","20081230","tbsd01"
420000,"123","fdsf","20090306","odemo"
370000,"01","供货商付款","20090407","bdemo"
370000,"02","批发客户收款","20090407","bdemo"
370000,"03","基础资金","20090407","bdemo"
270000,"01","出","20090506","fzadmin"
800000,"01","租金","20091029","515022"
800000,"02","租金","20091029","515023"
这是导出的结果,我想要表头,
那位前辈知道,希望能尽快得到答案