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

Top