清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
# from table to CSV require 'odbc' require 'dbi' filename = "./file.csv" writeFile = File.open(filename,"w") dbh = DBI.connect('DBI:ODBC:data_source_name', 'username', 'password') sth = dbh.prepare("SELECT * FROM table WITH UR") sth.execute writeFile.puts sth.column_names.join(" ; ") #puts names on the top of each row while row=sth.fetch do writeFile.puts row.join(" ; ") #puts lines from table end sth.finish dbh.disconnect writeFile.close # from csv to excel require 'win32ole' xl = WIN32OLE.new('excel.application') xl.workbooks.open(File.expand_path(filename)) xl.visible = true