Exporting from access to excel problem using vba.

[Guest]

I am trying to export a query from Access 2002 to Excel 2002 using VBA where
the query result has just under 30,000 rows. The following error message
appears -
'There are too many rows to output, based on the limitations specified by
the output format or by the database name.'
I have not set up any limits myself.
If you right click on the query and then export it works fine, but i want
the user to press a button on the switchboard which will either trigger a
macro or run some vba code.

 

[Guest]

use docmd.Transferspreadsheet instead of docmd.outputto