Output to Excel

P

paul bray

Hello,

I have just upgraded to Access 2000 and when I try to
output a query with 19000 records in it, I get the
following:

run-time error '2306'

"There are too many rows to output, based on the
limitation specified by the output format or by 'My Access
Database Name'"

Any help would be appreciated!

Cheers,

pb
 
C

chas

Hi Paul,

how are you outputting to Excel? If you are doing it
manually are you choosing the latest version of Excel (if
possible)? Excel does have a limit to the number of rows
in a worksheet and if the ISAM driver (converter) you are
using is an early version then you may be exceeding the
limit of rows allowed. Can you output less rows as a
test - say 1000 or so?

hth

chas
 
P

Paul B

Chas,

I am using the latest version of Excel, but don't seem
able to output more than 10 000 records? I used to be able
to before I upgraded??

Your help is much appreciated!

Cheers,

pb
 

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
Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo) 1
Trouble exporting Report to Excel 1
Access export to Excel stops at about 45,000 not 65,000 XL limit 11
Run-time error '2306' 3
output file 3
Limitation of rows to output 4
Unable to export all rows from a access query to excel 1

Top