Too many rows for Excel output from Access 2000

  • Thread starter Thread starter vtreddy
  • Start date Start date
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
 
IIRC, OutputTo uses an earlier Excel format that limits to 16K rows.

Use the TransferSpreadsheet Method instead. Check Access VB Help.
 
Back
Top