Analyze w/ Excel

  • Thread starter Thread starter MAXWELL
  • Start date Start date
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?
 
I believe that Analyze with EXCEL uses EXCEL 95 structure, which is limited
to 16000 (approximately) rows.
 
-----Original Message-----
I believe that Analyze with EXCEL uses EXCEL 95 structure, which is limited
to 16000 (approximately) rows.
Click to expand...

Correct.

If you need to copy 16,000 - 65,500 records into Excel,
your best bet is to either manually copy/paste into a
worksheet or do a TransferText to a new text file, then
import the text file into Excel. You can open a virtual
copy of Excel from Access to do the latter in VBA.

HTH,
 
TransferSpreadsheet allows use of EXCEL 97 and higher versions, which allow
65536 records to be exported to a spreadsheet.
 
Try an export of the table/query to Excel and clear the check box for
"formatting", instead of the "Analyze it with Excel" method.
 
Back
Top