LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mark
 
Posts: n/a
Default Can we extend the row limitation from 65536 to say 100K or higher

I wish to import data into Excel that is typically 90K rows long and could go
to as much as 900K. # of Columns is only say 20 or so.
is there any way to remove the 65536 row limit so the whole data set can be
imported at once?
Alternatively, is there some snippet of code or idea to import the data into
multiple sheets?
Many thanks for any advice.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"