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"
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"