Analyze It with MS Excel

G

Guest

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.
 

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

Similar Threads

Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet 1
analyze a queries with excel 2
Preserving the Hyperlink using DoCmd.TransferSpreadsheet 1
Analyze with excel 1
Analyze It with MS Office Excel 1
"Too Many Rows to Output" message 2
Command button for Analyze it with MS Office Excel? 2
analyze it with microsoft office excel 1

Top