• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Working with Database Data > Retrieving Data from a Database

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint