Too many fields!

[Rob A.]

I am currently trying to export the results of a query to
an Excel file. However, whenever I select the command to
run this event, I always get an error stating that I have
too many fields defined. I have one query that exports 13
fields of information, and it generates no errors. The
query that is giving me problems is only 11 fields of
information. Can anyone give me some tips about how to
fix this, or any idea of why this is happening? Both
queries export to the same file, but just target different
sheets within that file. I'm hopelessly confused ...

Thanks!

Rob Armstrong

 

[kripesh]

Compact teh database. and it should work fine.

 

[Rob A.]

Thanks for the help!

Unfortunately I had already tried that before, and it did
not work. I still am not allowed to export as many fields
of data from my query as I would like. Any other
ideas/suggetsions?

Thanks,

Rob