Problem to open excel file.

Question

Hello,
My application (based on dotnet 2.0 framework) have data 'export to excel' functionality and our application database in SQL Server 2000.  Export functionality is working fine.
But in one case exported excel file dont open and give following error message

"Excel found unreadable content in 'hello.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

Hello.xls is file name.

This error only occurred in following conditions:
1) If i exporting a field 'Summary' and only no. of rows is exceeds from 850 (its not an exact count) . This field type is varchar(5000).
2) if i exclude the 'summary' column data and export it more than 850 records it exported and file is open without any message or error.

In all other conditions exported file is open correctly. Please give the solution or root of the problem. Its urgent.

Answer 1

 

Ani Michal,

This forum is for helping customers interoperate with Microsoft Products via our Open Protocol Documentation. Information on this program can be found here: http://www.microsoft.com/protocols/default.mspx and the documentation itself can be found here: http://msdn.microsoft.com/en-us/library/cc203350.aspx. Your issue does not appear to be related to our protocol documentation.

The “Getting started with SQL Server” (http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/threads/) forum is most relevant to your particular issue.

Dominic Salemno
SENIOR SUPPORT ESCALATION ENGINEER