View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default import more than 65000 records into excel

Depending what you are trying to do you could hook an XL pivot table to the
Access database. The pivot cache is not limited to a specific number of
records. I have gone to a little over 1 million records that way... There is
a memory limit issue but with 90k records you should be ok...
--
HTH...

Jim Thomlinson


"mmatz" wrote:

I want to import 90,000 records into excel from an access table