title: How do I create very large excel files from access database?
body: <p>I have an issue right now where I believe my cold fusion code is trying to create a very large excel file after pulling records from an access database. I beleive it is timing out and giving a 500, null error. The cold fusion will need to process around 180,000+ records.  Is there an efficient way of doing this?</p>
  
  <p>Here is pretty much how it goes down:</p>
  
  <pre><code>    &lt;cfquery datasource="datasource" &gt;
  Drop Table Person
  &lt;/cfquery&gt; 
  
  &lt;cfquery datasource="datasource" &gt;
  Update1rowtble
  &lt;/cfquery&gt;
  
  
  &lt;cfset Clist=  "FNAME,LNAME,etc.."&gt;
  
  &lt;cfquery name="q" datasource="datasource" &gt;
  R2A&lt;/cfquery&gt;
  
  
  
  &lt;cffile action="WRITE" file="filepath" output='#toString(queryToXL(Q,Clist))#' addnewline="No" fixnewline="No"&gt;
  
   &lt;cfquery name="q" datasource="source" &gt;
  R3
  &lt;/cfquery&gt;
  
  &lt;cffile action="WRITE" file="filepath2" output='#toString(queryToXL(Q,Clist))#' addnewline="No" fixnewline="No"&gt;
  </code></pre>
  
  <p>Thanks</p>