Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
Hi,
As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your
memory -- Regards, Peo Sjoblom "Glinty" <Glinty @nomailatall.co.uk wrote in message ... Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
Thanks Peo, It looks like I'm going to have to start learning about Access
then. Cheers Glinty "Peo Sjoblom" wrote in message ... Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom "Glinty" <Glinty @nomailatall.co.uk wrote in message ... Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
Excel 2007 has over a million rows, of course it has a new radical design
hated by a lot of people and loved by a few -- Regards, Peo Sjoblom "Glinty" <Glinty @nomailatall.co.uk wrote in message ... Thanks Peo, It looks like I'm going to have to start learning about Access then. Cheers Glinty "Peo Sjoblom" wrote in message ... Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom "Glinty" <Glinty @nomailatall.co.uk wrote in message ... Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
"Peo Sjoblom" wrote in message
... Excel 2007 has over a million rows, of course it has a new radical design hated by a lot of people and loved by a few And in any case, Excel is a data MANIPULATION application, not a database. Anything with data approaching 60,000 records will be MUCH better served using a specific database application rather than Excel... |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
I agree, use a database for storing lots of records, then use Excel to query
the database whether it is using a database query or a pivot table.. Unfortunately many people use it as a database then complain when it is slow. -- Regards, Peo Sjoblom "Gordon" wrote in message ... "Peo Sjoblom" wrote in message ... Excel 2007 has over a million rows, of course it has a new radical design hated by a lot of people and loved by a few And in any case, Excel is a data MANIPULATION application, not a database. Anything with data approaching 60,000 records will be MUCH better served using a specific database application rather than Excel... |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Maximum number of rows in a excel 2003 work sheet
loved by a few
Can you name any of these fewg Gord |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
maximum number of rows | Excel Discussion (Misc queries) | |||
What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
Maximum number of rows? | Excel Discussion (Misc queries) | |||
Maximum number of rows | Setting up and Configuration of Excel | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) |