OutputTo action

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I have a query that i want to export to excel. This query retrieves about 40
000 records. When i export the query there's no problem, but when i try to
programme a DoCmd.OutputTo action i get the following error:
" Run-Time error 2306:
There are too many rows to output, based on the limitation specified by the
output format or by Microsoft Office Access."

Why does this happen?

Thanks
Luis
 
Hi,
try the Docmd.TransferSpreadSheet method instead!
HTH
Good luck
 
You must log in or register to reply here.

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

OutputTo PDF error 2501 The OutputTo action was cancelled 1
Limitation of rows to output 4
Error Handling on the Cancel of the OutputTo action 3
Output Query as an Excel file 2
OutputTo doesn't 2
Runtime error 2501 Output to / output Query / excel 8
Error on OutputTo 1
User cancels Dialog Box in OutputTo method 2

Back
Top