Excel ODBC and External Data Handbook

Excel ODBC and External Data : A guide to opening data sources to Microsoft Excel. This handbook walks through setting up ODBC connections to external data sources (such as Microsoft Access) using Excel's built-in External Data feature. This downloadable PDF book also includes a sample Excel file and Access database in case you want to follow along with the examples. The handbook contains screenshots, and includes navigation for both Excel 2003 and Excel 2007. The handbook is 19 pages. Topics include: an overview, selecting the data source, selecting the tables, selecting the columns, applying filters, parameter queries, specifying the criteria of a parameter query with Excel worksheet cells, aggregation within Microsoft Query, calculated fields, and web data imports.