在工作簿的多个工作表中将4个表从Sql数据库导出到Microsoft Excel [英] Exporting 4 tables from Sql database to Microsoft Excel in mutiple sheets in a workbook

问题描述

我想从SQl数据库中导出4个表.
每个表都有记录60000.
我想在工作簿中为4张桌子获得4张纸.
而且我也想在每张纸上获得列标题.
我尝试使用数据表和Com对象.
但是加载时间要花很多时间.
因此哪种方法是将大量数据导出到excel的正确方法?

I want to export 4 tables from SQl Database.
Each table has Record 60000.
I want to get 4 sheets for 4 tables in a workbook.
And i also want to get column headings in each sheet.
I tried with datatables and Com object.
But the loading time takes so much.
so which way will be the proper way for exporting large amount of data to excel???

推荐答案

pl参见以下线程
如何将数据从SQL SERVER导出到Excel [ ^ ]

以及以下CP文章:

从数据集快速导出到Excel [

pl see the following thread
How to export data from SQL SERVER to Excel[^]

and the following CP article:

Fast Exporting from DataSet to Excel[^]

这篇关于在工作簿的多个工作表中将4个表从Sql数据库导出到Microsoft Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！