Error 3190 - What is the limit

D

David

Hello all,
I am trying to export a cross tab query to excel. The crosstab query is 30
columns, with 30 rows. This is giving me the error 3190 - Too many fields
defined.

It worked previously, with fewer columns I presume. What is the limit and
is there another way to get this info in excel?

Here is the part of the code that gives the error

Dim strTempFile As String


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"qry_Milestone_History_Crosstab", strTempFile, True, "MileStones"
 
Top