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

Chapter 14. Advanced Spreadsheeting > Working with Databases

14.3. Working with Databases

Excel has much in common with database programs. Both kinds of software keep track of a list of records (like cards in a card catalog—or rows of a spreadsheet), and let you browse through those records and even perform some calculations on them. No wonder Excel is so adept at incorporating database files into its spreadsheets; Excel X can access data in Web pages and FileMaker Pro databases, and may be able to use open database connectivity to access data from additional databases. Open database connectivity, usually called ODBC (pronounced "oh-dee-bee-see"), is a standard set of rules for transferring information between databases, even if the databases are in different programs from different companies.

14.3.1. Fetching FileMaker Pro Data

Excel can import data from FileMaker Pro databases directly into its worksheets—no muss, no fuss, no messy translation workarounds.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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