Analyze w/ Excel

M

MAXWELL

I tried to analyze my Table with excel.

The table has only 28k rows, but it will not let me put it
out on excel...

Why?
 
K

Ken Snell [MVP]

I believe that Analyze with EXCEL uses EXCEL 95 structure, which is limited
to 16000 (approximately) rows.
 
K

Ken Snell [MVP]

TransferSpreadsheet allows use of EXCEL 97 and higher versions, which allow
65536 records to be exported to a spreadsheet.
 
R

RC West

Try an export of the table/query to Excel and clear the check box for
"formatting", instead of the "Analyze it with Excel" method.
 
Top