Too many rows for Excel output from Access 2000




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

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

Can any one suggest the solution to this problem,

Thanks in Advance,

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