Run-time Error 2306

J

Josie

I am trying to export a table to Excel. When i use File:Export , i have no problems. However, when I use OutputTo or analyze it With Excel, i get Run-Time Error 2306."There are too many rows to output, Based on the limitation specified by the output format or by LT database."

1. How do i set the Output format?
2. Why does it work form the file menu?
3. Can I export the table using something else that won't give me this error?

Josie
 

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
what is the maximum number of rows when exporting query to excel 3
Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo) 1
Excel does not accept text format! 0
Output to Excel 2
output file 3
too many rows to output 1
VBA - exporting serial letters to single documents 0

Top