Too many rows for Excel output from Access 2000

V

vtreddy

All:

In my application I am exporting several records to excel file
dynamically using a query,when the number of records exceeds 50000 records
in one of the scenarios I am getting this error :There are too many rows to
output, based on the limitation specified by the output format or Microsoft
access

Dim stDocName As String
stDocName = "Query11"
DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , 1

Can any one suggest the solution to this problem,

Thanks in Advance,
VT
 
V

Van T. Dinh

IIRC, OutputTo uses an earlier Excel format that limits to 16K rows.

Use the TransferSpreadsheet Method instead. Check Access VB Help.
 

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

Top