 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Maximum 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 Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory  SignatureRegards, Peo Sjoblom > Hi, > As a new user to excel I am thinking of setting up a data base of my [quoted text clipped - 7 lines] > Cheers > Glinty Thanks Peo, It looks like I'm going to have to start learning about Access then. Cheers Glinty > Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is > your memory [quoted text clipped - 10 lines] >> Cheers >> Glinty 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 SignatureRegards, Peo Sjoblom > Thanks Peo, It looks like I'm going to have to start learning about Access > then. [quoted text clipped - 14 lines] >>> Cheers >>> Glinty > 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... 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. SignatureRegards, Peo Sjoblom >> 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... > Unfortunately many people use it as a database then complain when it is > slow. I imagine that abuse was further encouraged when they added over 1 million rows. > 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.. [quoted text clipped - 7 lines] > > Anything with data approaching 60,000 records will be MUCH better served > > using a specific database application rather than Excel... >> Unfortunately many people use it as a database then complain when it is >> slow. > > I imagine that abuse was further encouraged when they added over 1 million > rows. Yes - I cannot IMAGINE any sane person using Excel with that amount of data - and I'm a retired (just!) Systems and Management Accountant... >>> Unfortunately many people use it as a database then complain when it is >>> slow. [quoted text clipped - 3 lines] > Yes - I cannot IMAGINE any sane person using Excel with that amount of > data - and I'm a retired (just!) Systems and Management Accountant... I agree but 65000 rows was a limit that I bumped against constantly. I work with a database with about 75000 SKU's and customer sales history that commonly exceeded the row limit. I was glad to see the increase. While most of what I needed could be done in Access sometimes it's just easier for me to do it in Excel. gls858 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.