runtime error 2306

B

BJ Freeman

have an sp that return 16,755 rows of data.
I can run the sp in the ADE and it displays all of them.
when I try to execute
DoCmd.OutputTo acStoredProcedure, "dbo.ADP_Exportinventory",
"MicrosoftExcel(*.xls)", CurrentProject.Path & "\" & "Inventory.xls", True,
""

I get a runtime error 2306
"there are too many rows to output, based on the limitation specified by the
output format or by "ADE name"
I have the row limit set at 100,000.

I think it has something to do with DDE limitation. I did not find anyting
in the knowledge base
 

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

Output Query as an Excel file 2
output file 3
ADE/ADP AC2000 DoCmd.OutputTo 0
too many rows to output 1
Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo) 1
Access 2K ADP Docmd Passing parm with acStoredProcedure 3
OutputTo action 1
Limitation of rows to output 4

Top