Maximum number of rows?
 

Hi

In Excel the maximum number of rows i can get is 65536. Is it possible to
extend this so i can get about 67000 rows?

Kind regards

Allan Bach

Hi


"Allan Bach" (DONOTSPAM) wrote in message
...
Hi

In Excel the maximum number of rows i can get is 65536. Is it possible to
extend this so i can get about 67000 rows?

Not on same sheet!

Your options:
Delete some abundant rows, when you have them;
Distribute your data to several worksheets;
Redesign your worksheet, so that the number of needed rows decreases (in
case it's possible to collect the info from several rows to one single row);
Switch to Access or to any other database application;
Swithc to QuattroPro.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



Kind regards

Allan Bach

Is it possible to have more than 65000 entries in Access?

kr.

Allan


"Arvi Laanemets" skrev:

Hi


"Allan Bach" (DONOTSPAM) wrote in message
...
Hi

In Excel the maximum number of rows i can get is 65536. Is it possible to
extend this so i can get about 67000 rows?

Not on same sheet!

Your options:
Delete some abundant rows, when you have them;
Distribute your data to several worksheets;
Redesign your worksheet, so that the number of needed rows decreases (in
case it's possible to collect the info from several rows to one single row);
Switch to Access or to any other database application;
Swithc to QuattroPro.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



Kind regards

Allan Bach

Allan Bach shared this with us in microsoft.public.excel.misc:

Is it possible to have more than 65000 entries in Access?

It's possible to have (approx.) 2,1 milliard records in Access, if I
remember correctly.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html

Hi

Microsoft Access (2000) database table specifications
Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables
open internally by Microsoft Access.
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the
user interface;
1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields)
2,000
Number of characters in a field property setting 255

As you see, no direct limitations for number of rows - it equals 1
Gb/RowSize, where RowSize depends on your table design. (Memo fields and
(when designed properly) OLE object fields contain only links.)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



"Allan Bach" (DONOTSPAM) wrote in message
...
Is it possible to have more than 65000 entries in Access?

kr.

Allan


"Arvi Laanemets" skrev:

Hi


"Allan Bach" (DONOTSPAM) wrote in message
...
Hi

In Excel the maximum number of rows i can get is 65536. Is it possible
to
extend this so i can get about 67000 rows?

Not on same sheet!

Your options:
Delete some abundant rows, when you have them;
Distribute your data to several worksheets;
Redesign your worksheet, so that the number of needed rows decreases (in
case it's possible to collect the info from several rows to one single
row);
Switch to Access or to any other database application;
Swithc to QuattroPro.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



Kind regards

Allan Bach

Arvi Laanemets shared this with us in microsoft.public.excel.misc:

Hi

Microsoft Access (2000) database table specifications

*snip* whole lotta numbers

As you see, no direct limitations for number of rows - it equals 1
Gb/RowSize, where RowSize depends on your table design. (Memo fields
and (when designed properly) OLE object fields contain only links.)

You are right, I was wrong. I was probably confusing with FoxPro, or
with the range of longint (which is used for record numbers, so my
guesstimate is not totally out of the blue)

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html