Using Excel with Microsoft Access

Object Libraries ■ Setting Up References to Object Libraries ■ Connecting to Microsoft Access ■ Using Automation to Connect to a Microsoft Access Database ■ Using DAO to Connect to a Microsoft Access Database ■ Using ADO to Connect to a Microsoft Access Database ■ Performing Microsoft Access Tasks from Excel ■ Creating a New Microsoft Access Database ■ Opening a Microsoft Access Form ■ Opening a Microsoft Access Report ■ Running a Microsoft Access Query ■ Calling a Microsoft Access Function ■ Retrieving Microsoft Access Data into an Excel Spreadsheet ■ Retrieving Data with the GetRows Method ■ Retrieving Data with the CopyFromRecordset Method ■ Retrieving Data with the Transfer-Spreadsheet Method ■ Using the OpenDatabase Method ■ Creating a Text File from Microsoft Access Data ■ Creating a Query Table from Microsoft Access Data ■ Using Microsoft Access Data in Excel ■ Creating an Embedded Chart from Microsoft Access Data ■ Transferring the Excel Spreadsheet to an Access Database ■ Linking an Excel Spreadsheet to a Microsoft Access Database ■ Importing an Excel Spreadsheet to a Microsoft Access Database ■ Placing Excel Data in an Access Table ■ What's Next...

In Chapter 9 you learned about controlling Microsoft Word and Outlook from Excel via Automation, which allows one application to control the objects of another application. This chapter shows you how to programmati-cally use Access from Excel and retrieve Access data into a spreadsheet by using the following methods: Automation, DAO (Data Access Objects), and ADO (ActiveX Data Objects). Before you learn how to use Excel VBA to perform various tasks in an Access database as well as retrieve and store data in an Access database, let's briefly introduce the data access methods that Microsoft Access uses to gain programmatic access to its objects.

0 0

Post a comment