[AccessD] Data from temp table being rammed into an Excel spreadsheet

Stephen Bond stephen at bondsoftware.co.nz
Mon Aug 29 16:02:00 CDT 2005


In A2K I have built a temp table and am trying to then export it to a spreadsheet using the following line of code:
 
  objXLRange.FormulaArray = objXLApp.Transpose(varResults)

where 'Dim objXLApp As Excel.Application ' 
and 'Dim objXLRange As Excel.Range' and has been defined precisely, according to the size of the incoming data in the temp table,
and varResults is a 2-dimension array being the result of SELECT * FROM tmpTable.  The column count is fixed at 18 but the Row count is variable.
 
This works well when the temp table has 303 rows or less.  Over 303 rows, and I get 'Error 13 Type Mismatch'.  I have looked for corrupted data coming in thru the query that creates the temp table, but after many hours of experimentation it comes back to an apparent limit on the number of Rows.
 
I don't remember where I got the code from and I don't pretend to understand the 'FormulaArray' property in Excel, but someone here might have been down this track .... any takers?
 
 
Stephen Bond 


More information about the AccessD mailing list