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.
 
T

Terrell Miller

-----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,
 
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.
 

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 With Excel (Access 2003 Bug ??????) 1
Exporting from Access to text 2
Flat File Database, Multiple Excel files into one Access Table 6
Windows 8.1 defragmentation issues 2
Export to Excel tool - "Analyze It with Microsoft Excel" doesn't w 3
office link feature to excel in Access 2007 1
*HOT* Exporting multiple subreports 2
Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet 1

Top