O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

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

Retrieving Data from a Database

Just as you can save an Excel workbook as a tab-delimited text file and then open it in other spreadsheet programs, you can also save data lists, or tables, that you’ve created in other database and spreadsheet programs and then import those tables into an Excel worksheet. Excel lets you go one step further, however. In Excel, you can reach directly into an Access, dBASE, Microsoft FoxPro, or Microsoft Visual FoxPro database and retrieve data from that database’s tables.

Three steps are required to bring data from a database into Excel: defining a data source, building a query to create a link to that data source, and, if desired, creating a filter to limit the rows that appear in your Excel worksheet.

To define a ...

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