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

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?

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.

"touresaa" <touresaa@discussions.microsoft.com> wrote in message
news:2EE7381C-667A-462F-A562-7D214A26BC61@microsoft.com...
> 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?

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?

If the total numbers of records is < 98000 then this may help...

http://support.microsoft.com/?kbid=119770
"Text Import Wizard Maximum Start Row Limitation Of 32767"


Jim Cone
San Francisco, USA


"touresaa" <touresaa@discussions.microsoft.com> wrote in message
news:2EE7381C-667A-462F-A562-7D214A26BC61@microsoft.com...
> 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?

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

"touresaa" <touresaa@discussions.microsoft.com> wrote in message
news:2EE7381C-667A-462F-A562-7D214A26BC61@microsoft.com...
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?