Thread: import more than 65000 records into excel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default import more than 65000 records into excel
You'll have to use VBA code to split the records across multiple worksheets.
See http://www.cpearson.com/excel/ImportBigFiles.htm for example code to do
this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"mmatz" wrote in message
...
I want to import 90,000 records into excel from an access table


Reply With QuoteReply With Quote