View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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