View Single Post
  #2   Report Post  
Bob Umlas
 
Posts: n/a
Default How to get more than 65000 rows in and excel spreadsheet

Wait for Excel 12! Over 1,000,000 rows, Seriously, there's no way to expand
this. It's fixed in stone and is always 65536. However, you can read records
in thru VBA code and break it onto new worksheets when you reach the limit,
but NOT by doing File/Open.

"Jake Clark" <Jake wrote in message
...
I am importing data into an excell spreadsheet that has 100,000 + records,
how do I expand on the 65,356 record limit that I see in Excell?