Microsoft Access 2010 provides users with the ability to import their contacts from the Address Book or Microsoft Outlook 2010 in Microsoft Windows 7 and then perform operations on them.
This guide covers how to import Outlook 2010 contacts into Microsoft Access 2010.
- Open Outlook 2010 and navigate to the Home tab in the ribbon and click on Address Book.
- A new dialog box will open showing you all your contacts and their details. Now Launch Microsoft Access 2010 and navigate to the External Data tab on the ribbon and then in More click on Outlook Folder.
- You will see the Get External Data-Outlook Folder dialog box, you can specify here where you want to store the data in current database. Select the option you see fit and click OK.
- Now select the source of the address book by selecting the Outlook Address Book and click Next.
- Access will now start importing your contacts from the Microsoft Outlook Address book. You can select/un-select various options here such as the field names which you want to give to the contacts e.g. address, cell number, office number etc. Also, you can choose which fields to import from Outlook or not.
- Choose primary key by selecting the option Let Access add primary key.
- Specify name for the imported table. Click Finish to review the contacts table made in Access 2010.
- Access will now be showing the contacts imported from Outlook in the form of a table with data entries. You can now perform the standard functions which can be performed on an Access table.
- In order to delete a column, right click and select the column and press Delete Field.
- That’s it, you can now arrange contacts more efficiently with their corresponding primary keys and attributes in Access 2010 and export them back to Outlook 2010.