evergreean
Technical User
I keep getting error message on my Excel output saying:
Cell data too large. After I hit the okay prompt the Excel spreadsheet comes up just fine but I dont want users to get that output message.
It only does it when I output over 60 records.
The fields all contain memo field data from an Access 2000 database.
I am using table to output my info:
Please advise. I am using Microsoft Office Excel 2003.
Cell data too large. After I hit the okay prompt the Excel spreadsheet comes up just fine but I dont want users to get that output message.
It only does it when I output over 60 records.
The fields all contain memo field data from an Access 2000 database.
I am using table to output my info:
Code:
<CFCONTENT type="application/msexcel">
<CFHEADER name="Content-Disposition"
value="attachment;filename=xs.xls">
<cfset NewLine = Chr(13) & Chr(10)>
<table>
<tr>
<td>header One</td>
<td>header two</td>
<td>header three</td>
</tr>
</table>
<cfoutput query="thequery">
<table>
<tr>
<td>#fieldOne#</td>
<td>#fieldTwo#</td>
<td>#fieldThree#</td>
</tr>
<table>