SECOND REQUEST "Too many rows to..." error

G

Guest

In my macro I have
Output Type = Table
where the tables has 27,121.

When I attempt to change the Output Format to Microsoft Excel 97-2002(*.xls)
from Micrsoft Excel (*.xls) in the dropdown box it defaults to Micrsoft
Excel (*.xls).

I suspect that this is the cause of the Output error. How can I correct
this problem
 
D

David Conger [MSFT]

Can you use Output To to export to other formats successfully? What is the
full error message?

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 
D

David Conger [MSFT]

Actually, take a look at Jerry Whittle's answer to your post in the
ExternalData newsgroup. His answer is better than my additional questions.
:)

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 

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

TOO MANY ROWS...SECOND REQUEST 1
Output to : Template file 3
Need to export multiple files 3
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Microsoft Access can't start the OLE Server 0
Error message with Macro 1
DoCmd.OutputTo error 2606 too many rows 1
Access 2007 Macro bombs when run with Access 2003 1

Top