How to Use Access to Extract Data From Outlookby Bennett Gavrish
When using the Microsoft Access application to create database files, you can choose to import data from a variety of sources or programs. One of the import options is Outlook, one of the most popular email clients among PC users. When using Access to extract data from Outlook, you can choose to import information from your calendar, contacts or mailboxes.
Open the Microsoft Access program on your PC computer.
Open the database file that you want to use to extract Outlook data. If you want to start with a blank database, you can click on the "Create a new file" button.
Open the "File" menu at the top of the window, go into the "Get External Data" folder then select "Import."
Select "Outlook" as the file type and wait for the Import Wizard window to open.
Click on the mailbox, address book or calendar that you want to extract, then hit "Next."
Choose to either add the Outlook data to a new table or an existing table in the database, then hit "Next" again.
Modify the field names then hit "Finish" to extract the selected data from Outlook.
Items you will need
- PC running Windows XP or later
- Microsoft Office 2000 or later
- Ciaran Griffin/Stockbyte/Getty Images