由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - 想report SQL Server 2008的一个不足之处--output more than 1 million rows into EXCEL
相关主题
mysql: how to format output?how to get the result in the middle of resultset?
SSIS import and export wizard 搞不定了oracle load数据怎么会这么慢?
包子重酬,帮作2道题how to register SQL Server in intranet
请教:PL/SQLMS SQL Server copy database wizard
用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗sql server 面试题 (8)
excel 数据中间有‘|’如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?
一个SQL写法性能的请教扯扯Senior SQL Server DBA咋整 (2)
error of importing data from txt file to IBM netezza SQL da (转载)MS T-SQL 问题
相关话题的讨论汇总
话题: excel话题: output话题: wizard话题: file话题: sql
1 (共1页)
m*********y
发帖数: 389
1
I was trying to use SQL Server 2008's Import and Export Wizard to report
more than 1 million rows directly into EXCEL. Every time when I choose from
a list of the Excel versions they support, I chose 'Excel 2003' -- obviously
, only Excel 2003 and above version allow more than 65k records. Then I
specify the output file name and location and click 'Finish'.. However, the
wizard would ignore the version I selected for Excel, and still went ahead
and exported into an earlier versions of Excel, like Excel 97... the final
Excel output file would contains about 65k.. You can imagine how pissed off
I am ...
Later I figured out the solution: create the Excel 2003 output file FIRST,
as opposed to specifying the output file name in the Wizard.. and then in
the Wizard, go to the path of the file I already created and select the file
, and then I got the output file that contains the 1 million (here 1 mil is
just a ballpark number) records..
The whole process took me couple of hours to figure out...
Now I am thinking of reporting this inefficienty to MS, how do I report a
bug to MS?
i****a
发帖数: 36252
2
it's not a limitation on SQL server. It's a well known limitation on
excel, I've ran into this a few times and have to custom program output
to different worksheets to get around it.
according to M$, excel 2003 limits to 65k rows, 2007+ is "over one
million rows"
http://msdn.microsoft.com/en-us/library/ff700514.aspx

report
from
obviously
I
However,
the
ahead
final
pissed
off
FIRST,

【在 m*********y 的大作中提到】
: I was trying to use SQL Server 2008's Import and Export Wizard to report
: more than 1 million rows directly into EXCEL. Every time when I choose from
: a list of the Excel versions they support, I chose 'Excel 2003' -- obviously
: , only Excel 2003 and above version allow more than 65k records. Then I
: specify the output file name and location and click 'Finish'.. However, the
: wizard would ignore the version I selected for Excel, and still went ahead
: and exported into an earlier versions of Excel, like Excel 97... the final
: Excel output file would contains about 65k.. You can imagine how pissed off
: I am ...
: Later I figured out the solution: create the Excel 2003 output file FIRST,

g***l
发帖数: 18555
3
EXCEL文件FORMAT是最烂的,宁可用CSV或者TAB DELIMITED TEXT FILE,也不用EXCEL
m*********y
发帖数: 389
4
I know!! But client requested Excel, not that I have a choice.
At the end, I was able to export about 1.5 million records into an Excel
2010 workbook. But I was only able to do that by following this order: first
, create the Excel 2010 workbook, then in the Wizard destination, find the
path and location of the already created Excel 2010 workbook... the default
of the export Excel is Excel 97.. that is what I am complaining about...
Anyway, looks like users just take it as it is, can't do nothing about it??
We pay for the license...
H*******g
发帖数: 6997
5
TAB DELIMITED FTW

【在 g***l 的大作中提到】
: EXCEL文件FORMAT是最烂的,宁可用CSV或者TAB DELIMITED TEXT FILE,也不用EXCEL
i****a
发帖数: 36252
6
did you read my reply?
use multiple sheets
or use multiple files if you don't want to deal with sheets

Excel
first
the
default
about...
it?
?

【在 m*********y 的大作中提到】
: I know!! But client requested Excel, not that I have a choice.
: At the end, I was able to export about 1.5 million records into an Excel
: 2010 workbook. But I was only able to do that by following this order: first
: , create the Excel 2010 workbook, then in the Wizard destination, find the
: path and location of the already created Excel 2010 workbook... the default
: of the export Excel is Excel 97.. that is what I am complaining about...
: Anyway, looks like users just take it as it is, can't do nothing about it??
: We pay for the license...

1 (共1页)
相关主题
MS T-SQL 问题用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗
SQL server to ODBC export questionexcel 数据中间有‘|’
求助:ssis输出到excel,自动在每个cell添加了single quote。如何避免一个SQL写法性能的请教
Import data from excel into sql server 2000error of importing data from txt file to IBM netezza SQL da (转载)
mysql: how to format output?how to get the result in the middle of resultset?
SSIS import and export wizard 搞不定了oracle load数据怎么会这么慢?
包子重酬,帮作2道题how to register SQL Server in intranet
请教:PL/SQLMS SQL Server copy database wizard
相关话题的讨论汇总
话题: excel话题: output话题: wizard话题: file话题: sql