Microsoft® Office Excel 2003 Programming Inside Out

Chapter 22. Excel and the Structured Query Language

Comparing Spreadsheets and Databases

Manipulating Databases with SQL

The Select Statement

The Insert Statement

The Update Statement

The Delete Statement

One of the many useful features of Microsoft Excel is its ability to access information in databases. You can copy information from a database table to a worksheet or from a worksheet to a database table. You can even combine information from a Microsoft Access database or a Microsoft SQL Server database with a user form.

This chapter serves as a brief introduction to using databases such as Microsoft Access and Microsoft SQL Server with Microsoft Excel. Because designing an effective database is beyond the scope of this book, design is not discussed ...