View Single Post
  #3   Report Post  
John Mansfield
 
Posts: n/a
Default

Unfortunately, you can't get around the 65,000 line per worksheet limitation.
You could add something to your download program to split the downloaded
file into total rows less than 65,000 and then load in into seperate
worksheets. For example, UNIX has a "split" command that allows you to
define the number of rows to be loaded into a downloaded file. Oher than
that, you might have to do more than one download to accomodate your needs.

----
Regards,
John Mansfield
http://www.pdbook.com

"touresaa" wrote:

when download large data to an excel file, it can accomodate only (65,000)
records only, so how i can change this limitaions to have more entriy?