Discussion Locked

Limit to Rows in Excel, Records in Acces

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How many rows can you have in a MS Excel 97 worksheet?

How many records can you have in a MS Access 97 table?

5 replies

by dklippert

There are 65,536 rows in an Excel spreadsheet.
The number of records in an Access table is limited by, for one thing, maximum size of the database. However ms does say:
"If you use a Counter as the primary key, a table can contain up to four billion records."

by fossil

Just a tip -- when I've needed more than the 65536 rows, I use multiple worksheets within ht workbook to hold the info and have the formulas/calculations on a separate worksheet reference all the worksheets.

This discussion is closed to new replies.