export crosstab query too many fields error

  • Thread starter Thread starter ktdid
  • Start date Start date
K

ktdid

Hello all -
I have a table with 6 fields and 1100 records. I use a crosstab query to
view the data in the format I need. That works great. When I try to export
it to Excel, however, I get an error of too many fields defined. Using the
compact and repair utility does not help. I use TransferSpreadsheet in a
macro to move the data to Excel. The error also occurs if I try to export
from the query. Any help would be very much appreciated.
 
I should probably mention that the crosstab query has about 50 columns and
about 35 rows.
 
Back
Top