Export to excel problem

Last Post 19 Apr 2004 11:51 AM by SQL Pro. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
redearth
New Member
New Member

--
16 Apr 2004 07:41 AM
Hi All,
When exporting to excel after publishing any one of my reports to a web document, I get a excel file that’s 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

SQL Pro
New Member
New Member

--
19 Apr 2004 11:51 AM
I believe the export to Excel function only works with Excel XP and above
You are not authorized to post a reply.

Acceptable Use Policy