When I use the Outputto command to output a query to Microsoft Excel and it exceeds approx. 16,000 rows of data, I get a "Runtime Error 2306 there are too many rows to output, based on the limitation specified by the output format or by Microsoft Access." Where is the limitation at, in the acFormatXLS command or in Access. Is there anyway to work around this?


My code looks like this:

filename = "CSA.xls" '& strCSA
DoCmd.OutputTo acOutputQuery, "qryjj2", acFormatXLS, filename, True

Thanks for any and all help.