export crosstab query too many fields error

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.
 
K

ktdid

I should probably mention that the crosstab query has about 50 columns and
about 35 rows.
 

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

Similar Threads

Append Crosstab Query to Existing Table 0
export crosstab query too many fields defined 3
Access error 3059 0
too many fields - hair tearing out at this point 2
Converting isse with Export in Outlook 0
Too Many Fields Defined Error 1
"Too many fields defined" Error 6
export to Excel - too many fields defined 0

Top