Analyze It with MS Excel

R

Rowdy

What is them maximum row output when using the Tools/Office Links/Analyze It
with MS Excel ? I know the Excel limits the row count to 65,536. The query I
am trying to analyze with excel has only 30,319 rows.
 
V

Van T. Dinh

IIRC, Analyze with Excel uses an earlier file format of Excel which can only
handle 16K rows.

If you need to Export to Excel, use TransferSpreadsheet.

Check Access VB Help on the TransferSpreadsheet method.
 
Top