SYMPTOMS
If a table has more than 16,384 rows, and you click the Office Links button, and then Analyze It with MS Excel, you may receive the following error:
There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access.
This happens as well with Microsoft Excel 2000, even though the maximum worksheet size for Excel 2000 is 65,536 rows by 256 columns.
CAUSE
For backward compatibility, Microsoft Access defaults to the Excel 5.0 specification, which is limited to 16,384 rows. Also, Access does not check the row count before attempting to send the data to Excel.
RESOLUTION
To work around this behavior, use one of the following methods:
Use Excel to import the data from Access.
In Access, click Export on the File menu, and then export to Microsoft Excel 97-2000 format. Make sure that the Save formatted check box in the Export Table dialog box in Access is not selected. Then open the file in Excel.
Limit the number of rows sent to Excel by creating a query in Access and setting the TopValues property to 16,384. Then, analyze the query with Microsoft Excel.
