Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
exporting to excel
1 view
Skip to first unread message
jvcoach23
Dec 23, 2009, 9:25:01 AM12/23/09
to
From what i can tell... when you export from SQL 2008 sp1 to excel, it
exports it as excel 97-2003 format. That format allows for 256 columns or
less. From doing a bing, it appears that excel 2005 on up supports a lot
more columns then 256. Is that true. If that is true, does anyone know if
RS is going to start letting you export to a newer version of excel and
export to more than 256 columns. It doesn't look like R2 is going to.
http://msdn.microsoft.com/en-us/library/ms159836%28SQL.105%29.aspx
exports it as excel 97-2003 format. That format allows for 256 columns or
less. From doing a bing, it appears that excel 2005 on up supports a lot
more columns then 256. Is that true. If that is true, does anyone know if
RS is going to start letting you export to a newer version of excel and
export to more than 256 columns. It doesn't look like R2 is going to.
http://msdn.microsoft.com/en-us/library/ms159836%28SQL.105%29.aspx
"The maximum number of columns in a worksheet is limited to 256. If this is
exceeded, the renderer displays an error message."
any info would be great.
thanks
Bruce L-C [MVP]
Dec 23, 2009, 9:59:14 AM12/23/09
to
A way around this would be to export CSV. This will automatically be shown
in Excel. And it is very fast as well.
in Excel. And it is very fast as well.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jvcoach23" <jvco...@newsgroup.nospam> wrote in message
news:B997C55A-0434-44FC...@microsoft.com...
0 new messages