title: Exporting crosstab query results to Excel from within MS Access
body: <p>I've been trying with limited success to export a crosstab query result set to Excel using Access 2003. Occasionally, the export works correctly, and Excel shows with no errors. Other times, using the exact same query parameters, I get a 3190 error - too many fields. I am using the TransferSpreadsheet option in a macro that is called from VB code.</p>
  
  <p>The macro has the following parameters:
  Transfer type: Export
  Spreadsheet type: Microsoft Excel 8-10
  Table Name: (this is my query name)
  File Name: (Excel output file, which exists in the directory)
  Has Field Names: Yes</p>
  
  <p>The query should not produce any more than 14 columns worth of information, so the Excel 255 col limit should not be a problem. Also,the data in the database is not changing during the time I am querying, so the same query will produce the same result set.</p>
  
  <p>One of the only solutions I have read on the net thus far is to close the recordset before running the macro, but this is hit or miss.</p>
  
  <p>Your thoughts/help are greatly appreciated!</p>