Special Edition Using® Microsoft® Office Excel 2003

Chapter 29. Using Excel with Access and Other Databases

by Bill Bruns

In this chapter

• Using Excel with Database Software

• Using Access to Complement Excel

• Exporting Excel Data into Other Databases

• Retrieving Data from Access and Other Relational Databases

• Importing Data from Text Files

Using Excel with Database Software

Excel is no slouch at handling data. With its sophisticated list-handling capabilities (which you can read more about in Part IV, “Using Excel’s Analysis Tools”), you can easily sort or filter data to find key values, as well as create subtotals and custom formulas to see the big picture.

However, if you want a more comprehensive and multifaceted way to keep track of your data, you might be interested in looking at a relational database. ...