how to overcome excel file limitaions (65,000) records only?

T

touresaa

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?
 
A

Alan Perkins

I'm afraid that you can't - at least not without using VB to split the file
across multiple worksheets.

I know it's not what you wanted to hear, but that's the way Excel is
designed.

Have you thought of using Access instead of Excel? There's no such
limitation there.

Alan P.
 
J

John Mansfield

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.
 
B

Bill Sharpe

There's always Quattro Pro, which allows up to 1,000,000 rows. I'd agree
with another poster that once you go over 65,000 records you're better
off using a database program such as Access.

Bill

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?
 
Top