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 ...
Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
