Managing data with Microsoft Excel - Carlberg, Conrad George (Indianapolis, IN : Que, 2004)
1. Misusing Excel as a database management tool -- 2. Excel's data management features -- 3. Excel's lists, names, and filters -- 4. Importing data: an overview -- 5. Using Microsoft Query -- 6. Importing data: further considerations -- 7. VBA essentials reviewed -- 8. Opening databases -- 9. Managing database objects -- 10. Defining fields and records with ActiveX data objects and data access objects -- 11. Getting data from Access and into Excel with ADO and DAD -- 12. Controlling a database from excel using ADO and DAD
"Applicable for versions of Microsoft Excel 97 to 2003"--P. [4] of cover
Includes index
Keywords: Microsoft Excel (Computer file); Business -- Computer programs; Electronic spreadsheets