Chapter 17. Setting Up a List or Database in Excel

Using Excel as a Database Program

Although “number crunching” is Excel’s primary purpose, the row-and-column format lends itself to creating and storing databases (called lists in Excel). Generally, a good general rule is that if your list grows to more than 2,000 rows, you should consider storing the information in a data warehouse or relational database such as Microsoft Access. Whether you need to store a product catalog for quick lookups or employee information for use with your accounting software, you can ...

Get Special Edition Using® Microsoft® Office Excel 2003 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.