Export to excel problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export to excel problem

Hi All,
When exporting to excel after publishing any one of my reports to a web document, I get a excel file that#%92s filled with what looks like headers and encrypted code or data. Not at all the target report.
The same reports do fine with exporting to PDF, CSV, html, etc.
I am running win 2000, excel 2000 and I am testing a 120-day evaluation version of SQL Server 2000 reporting services.
Any help would be greatly appreciated,
Thanks,
Nathan Below is the mess of text that I exported from the bad excel file as a .txt file… MIME-Version: 1.0
X-Document-Type: Workbook
"Content-Type: multipart/related;boundary=""—-=_NextPart_01C35DB7.4B204430""" This is a multi-part message in MIME format. ——=_NextPart_01C35DB7.4B204430
Content-Type: text/html;
"charset=""utf-8"""
Content-Transfer-Encoding: base64
Content-Location: file:///c:/Report.htm 77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zPSJodHRwOi8vIHd3dy53My5vcmcvVFIvUkVDLWh0bWw0MCI+CjxoZWFkPgbW5zUmlnaHREZXRhaWwvPjx4OkRvTm90RGlzcGxheUdyaWRsaW5lcy8+PHg6UHJpbnQ+PHg6VmFsaWRQcmludGVySW5mby8+PHg6UGFwZXJTaXplSW5kZXg+MDwveDpQYXBlclNpemVJbmRleD48L3g6UHJpbnQ+PC94OldvcmtzaGVldE9wdGlvbnM+PC94OkV4Y2VsV29ya3NoZWV0PjwveDpFeGNlbFdvcmtzaGVldHM+PC94OkV4Y2VsV29ya2Jvb2s+PC94bWw+PC9oZWFkPgo8L2h0bWw+
——=_NextPart_01C35DB7.4B204430
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Location: file:///c:/Sheet1.htm 77u/PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIHJpbnQ+PHg6VmFsaWRQcmludGVySW5mby8+PHg6UGFwZXJTaXplSW5kZXg+MDwveDpQYXBlclNpemVJbmRleD48L3g6UHJpbnQ+PC94OldvcmtzaGVldE9wdGlvbnM+PC94bWw+PC9oZWFkPgo8L2h0bWw+
——=_NextPart_01C35DB7.4B204430
Content-Type: text/css
Content-Transfer-Encoding: base64
Content-Location: file:///c:/stylesheet.css

I’m not sure why it errors, but can you check on levels of service pack on SQL & Excel. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I am using excel 2000 9.0.6926 with SP3
and SQL server 8.00.760 with SP3
Everything is up to date… I just dont get it
quote:Originally posted by redearth I am using excel 2000 9.0.6926 with SP3
and SQL server 8.00.760 with SP3
Everything is up to date… I just dont get it

Im sorry its – SQL server 2000 (8.00.760 with SP3)
Microsoft say that they have engineered RS to only work with Excel 2003 and above they hope to get it to work with 2000 in their first service pack Graham
]]>