Exporting access table to excel through Office link option

  • Thread starter Thread starter Adlin G
  • Start date Start date
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
 
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...
 
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.
 
Back
Top