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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top