O'Reilly logo

Special Edition Using® Microsoft® Office Excel 2003 by Patrick Blattner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required