Error: Too many rows to output?

  • Thread starter Thread starter Bradley C. Hammerstrom
  • Start date Start date
B

Bradley C. Hammerstrom

A2K

My app catalogs all the files on a given CD using a Module, modPath_File,
which contains, Sub ReadFileInfos. In the module a constant,
cgMaxSubfolders, was set to =40 but I changed it 1000 in an effort to
correct this error. It didn't work.

The error occurs after clicking a command button that runs a macro with
OutputTo action and specifying the Output Format as an Excel (*.xls) file.
The output object specified is tblCatalog created during the Sub
ReadFileInfos. The error dialog is created by Access, not Excel. Excel will
not launch.

The error reads: "There are too many rows to output, based on the
limitations specified by the output format or by [database.mdb]."

The Catalog table has about 20,000 records (one record for each file on the
CD) read from about 650 folders (incl. subfolders).

Any ideas?

Brad H.
 
Found my own answer at:
http://www.kbalertz.com/kb_Q201589.aspx

Due to backward compatability the max rows is 16,340 (as in Excel 5.0) which
is result of OutputTo action.
A manual File>Export, however, gives you the option of three different Excel
versions one of which is Excel 97/2000 which allows 65,000+ rows.
 
If you want to use code, use the TransferSpreadsheet Method rather than
OutputTo.

--
HTH
Van T. Dinh
MVP (Access)


Bradley C. Hammerstrom said:
Found my own answer at:
http://www.kbalertz.com/kb_Q201589.aspx

Due to backward compatability the max rows is 16,340 (as in Excel 5.0) which
is result of OutputTo action.
A manual File>Export, however, gives you the option of three different Excel
versions one of which is Excel 97/2000 which allows 65,000+ rows.

A2K

My app catalogs all the files on a given CD using a Module, modPath_File,
which contains, Sub ReadFileInfos. In the module a constant,
cgMaxSubfolders, was set to =40 but I changed it 1000 in an effort to
correct this error. It didn't work.

The error occurs after clicking a command button that runs a macro with
OutputTo action and specifying the Output Format as an Excel (*.xls) file.
The output object specified is tblCatalog created during the Sub
ReadFileInfos. The error dialog is created by Access, not Excel. Excel will
not launch.

The error reads: "There are too many rows to output, based on the
limitations specified by the output format or by [database.mdb]."

The Catalog table has about 20,000 records (one record for each file on the
CD) read from about 650 folders (incl. subfolders).

Any ideas?

Brad H.
Click to expand...
Click to expand...
 
Back
Top