Chapter 16Chapter 16
Using Excel with
Microsoft Access
Object Libraries + Setting Up References to Object Libraries +
Connecting to Access + Opening an Access Database + Using
Automation to Connect to an Access Database + Using DAO to
Connect to an Access Database + Using ADO to Connect to an
Access Database + Performing Access Tasks from Excel + Creat-
ing a New Access Database with DAO + Opening an Access Form +
Opening an Access Report + Creating a New Access Database with
ADO + Running a Select Query + Running a Parameter Query +
Calling an Access Function + Retrieving Access Data into an
Excel Worksheet + Retrieving Data with the GetRows Method +
Get Excel 2007 VBA Programming with XML and ASP 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.
