title: Excel table loses number formats when data is copied from ADODB recordset
body: <p>I'm updating an excel table from an <strong>ADODB</strong> recordset using the <code>CopyFromRecordset</code> method. </p>
  
  <p>After the update, the numbers show up as dates wherever there are number columns. </p>
  
  <p>The workaround I used until now is to format the columns back to numbers through <strong>VBA</strong>, but it's not a good solution as takes more time for the report to complete. Also I have to write code to accommodate a lot of tables. </p>
  
  <p>Is there a quick fix? Any help is greatly appreciated.</p>
  
  <pre><code>'Delete old data and copy the recordset to the table
  Me.ListObjects(tblName).DataBodyRange.ClearContents
  Me.Range(tblName).CopyFromRecordset rst
  </code></pre>
  
  <p><code>tblName</code> - refers to an existing table that held data of the same format/datatype as rst data</p>