Exporting access table to excel through Office link option

A

Adlin G

When I try to export a Access table with less than 65K
records and more than 14K records using "Analyze It with
MS Excel" option, it doesn't allow exporting and I get the
message of too many rows, when excel max rows is 65K.
Any suggestion how to fix it?
Thanks in advance
 
L

landg

I just saw a knowledge base article that said something
about a 14k limit on "Analyze It with MS Excel" - I don't
use that myself, but maybe you could do a search on the
Knowledge Base in MS?

good luck...
 
J

Joe Fallon

It has to do with the verison of Excel used in Analyze code.
It is an old version that only has ~16,000 rows.

Use TransferSpreadsheet and specify a newer version of Excel.
 
Top